Forum Discussion

amalrio's avatar
amalrio
Helper V
5 years ago
Solved

change date format

Hi my date column is in the format of MM/DD/YYYY.  I need to change it to be DD/MM/YYYY is this posible using a calculated column ?   below is how it looks at the moment    
Need Help
Show and Tell
Tips and Tricks
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi amalrio 

    ok no probs. What you need to do is convert the dates based on Locale.

    Assuming you start with dates like this

     

    Right click the column and choose Change Type -> Using Locale

     

    Then select the locale of the origin data - set the Data Type to date and as these are m/d/y dates we choose English (United States) for Locale

     

    Click OK and you should get 

     

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi amalrio 

No, not if you want to keep the data as a date type.  You can change it to text but I wouldn't advise doing that.

You're seeing the dates as m/d/y because that's what your PC regional settings are set to.  You could change your regional settings to d/m/y ?

Why do you have to have dates as d/m/y?  What exactly are you trying to do?

regards

Phil