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...
Need Help
  • 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

ask's avatar
ask
Helper III
9 years ago

Thanks. That was I did. It returned the error.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi ask

 

Which one returned the error, Using Locale or re-creating the Date column?

  • ask's avatar
    ask
    Helper III
    9 years ago

    yes

    • GilbertQ's avatar
      GilbertQ
      Super User
      9 years ago

      I would then suggest trying the second method I mentioned.

       

      I have used that in the past to overcome Date issues successfully.

    • ask's avatar
      ask
      Helper III
      9 years ago

      Using th local one, it returns the error

      • ask's avatar
        ask
        Helper III
        9 years ago

        what happen after refreshing the data for the second one, there will be new data coming