How to convert different date formats in data factory data flow? RRS feed

  • Question

  • hello, i am new at azure data flow.


    i have data with a date-row. unfortunately the dates are in two different date formats.

    for example:





    i got the data from an excel file and want to upload it with azure blob storage. then transform with data flow in data factory and load the data into an azure database.


    how can i transform the data into a single format? which component do I need? thank you very much



    p.s. sorry for my bad english

    Wednesday, September 11, 2019 12:05 PM


  • Hi marino88,

    You could try this expression in Derived column of Data flow: 

    iifNull(toDate(Column_3, 'dd.MM.yyyy'), toDate(Column_3, 'yyyy-mm-DD'))

    Here is the sample I used:

    Source Data Preview:

    Derived Column Data Preview:

    Output Data Preview:

    Hope this helps

    Thank you

    If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered"Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster.

    Wednesday, September 11, 2019 11:52 PM