i m trying to convert the string todate() in format 'mm-dd-yyyy' [i.e., 01-21-2022] in ADF dataflow. it looks it could not be done. it always converts to yyyy-mm-dd.. Is there anyway, i could able to convert into this format 'mm-dd-yyyy'

CodePudding user response：

Low mm is minutes. Use upper case MM for months.

CodePudding user response：

Convert Date to String format

toString(toDate('01-21-2022'), 'MM/dd/yyyy')