Forum Discussion

ask's avatar
ask
Helper III
9 years ago
Solved

Date Format

Hi,   date format  in the original data source is text format  as shown below . 30/05/2017   I want to convert it into US date format as date type. It returns error : (even though I use th...
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    This code should work below.

     

    =[#"Day"] & "/" & [#"Month"] & "/" & [#"Year"]

    Then once you have that column created, convert the data type to Date