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

JH-AM 41 Reputation points
2021-01-18T18:59:35.807+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nasreen Akter 10,811 Reputation points Volunteer Moderator
    2021-01-19T01:46:55.857+00:00

    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!

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.