Forum Discussion
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
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.
5 Replies
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
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
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
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.
