Forum Discussion
Dateformat must be the same for all users even on different locale settings
Hi Techcommunity ! I am struggling to "lock" date format in only one format regardless dateformat source (for both Excel Web and App) --> due to Windows local settings it might be difficult but...
ISO 8601
It is an international standard for representing dates.
https://en.wikipedia.org/wiki/ISO_8601
In essence, it is the format "yyyy-mm-dd".
It is logical, unambiguous but distinctly unfamiliar to most.
By way of example, I know, without shadow of doubt, that 7/4/22 is the 7th April, whereas I would see 2022-07-04 that way, even if it needed a double take to read it at all.
- Hi
Thanks for a lot for this reply.
One point I did not precise : dateformat outcome must not only be the us one.
It could be anything else as long as I chose only one dateformat as outcome.
Lets pick up the iso one.
It worked indeed, I tried it last week but was not working for all date format especially with the Russian one...
Could not transform the dd.mm.yyyy into the iso one.
Any idea how to proceed?
Thanks.
