'ADF dataflow todate function

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'

azureazure-data-factoryto-date


Solution 1:[1]

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

Solution 2:[2]

Convert Date to String format

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mark Kromer MSFT
Solution 2 BhanunagasaiVamsi-MT

Related Questions