Convert date format dd.mm.yyyy to toDate yyyy-MM-dd

Question

Convert date format dd.mm.yyyy to toDate yyyy-MM-dd

JH-AM 41

Hi I'm new to ADF, I have a date column with data in form dd.mm.yyyy which I want to change to the standard toDate in derived columns dataflow step. Tried a replace function and can get a string with dd-mm-yyyy but cant then extend expression to change toDate.

Anybody that can help?

Thanks in advance

HarithaMaddi-MSFT 10,146 Reputation points

2021-01-20T06:57:22.453+00:00
Hi @JH-AM ,

We have not received a response from you. Please let us know if below suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

--

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
HarithaMaddi-MSFT 10,146 Reputation points

2021-01-21T12:01:10.363+00:00

Hi @JH-AM ,

We still have not heard back from you. Please suggest if below shared approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

1 answer

Your answer

HarithaMaddi-MSFT 10,146 Reputation points

2021-01-20T06:57:22.453+00:00

Hi @JH-AM ,

We have not received a response from you. Please let us know if below suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

--

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
HarithaMaddi-MSFT 10,146 Reputation points

2021-01-21T12:01:10.363+00:00

Hi @JH-AM ,

We still have not heard back from you. Please suggest if below shared approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

Answer 1

Nasreen Akter 10,811 Volunteer Moderator

Hi @JH-AM ,

Please try toDate and toString functions e.g., toString(toDate(dateColumn, 'dd.MM.yyyy'), 'yyyy-MM-dd HH:mm:ss'). Thanks! :)

Datetime Format: https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

----------

If the above response helps, please "accept as answer" and "up-vote" the same! Thanks!

Share via

Convert date format dd.mm.yyyy to toDate yyyy-MM-dd

1 answer

Your answer