change date format

[amalrio]

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

[PhilipTreacy · Accepted solution]

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]

Hi @amalrio 

I really don't advise changing to text.  It's going to make things really complicated.  If you want to go back to date later you have to reformat/rearrange the text strings.  

Why can't you leave it as it is?  Why do you have to see date as d/m/y?

Or change your regional settings to d/m/y if you must see the dates as d/m/y?  But then, I assume you regional settings are set to match where you are, and switching them back and forth isn't ideal either.

regards

Phil

[amalrio]

the data extract I get from the system has M/D/Y format, my Locale settings are D/M/Y so the report output is not the way I want to be as my locale date setting thinks it is all January. @PhilipTreacy  Thanks

[amalrio]

@PhilipTreacy ,

 would you tell me how do I change it text and maybe convert to date after

[PhilipTreacy]

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