how could I change the date format from this yyyy/mm/dd to this dd/mm/yyyy in a ADF dataflow?. And I needed the date without timestamp

Question

I want to change a date that I have in this format 'yyyy/mm/dd' to this other format 'dd/mm/yyyy' and I don't want the date with timestamp.

Important: the date source will come as a string field and I want convert it to date field

This task will be in a dataflow in ADF

Answer 1

Hello @Gustavo Antón,

Did you try "Derived Column" transformation inside the DataFlow, using the toTimestamp expression function?

DATA FLOW:

Derived Column Expression:
Input format: 2023-05-26T04:54:49Z

Output Format: 26/05/2023 (No time)

toString(toDate(toTimestamp(DataLakeModifiedDateTime, 'yyyy-MM-dd'T'HH:mm:ss'Z'')), 'dd/MM/yyyy')

Output CSV showing the updated Date format : 'dd/mm/yyyy'

Please let us know if you need further help in this matter and we are happy to help!
If the response is helpful, please click "Accept Answer" and upvote it. So that we can close this thread.