Forum Discussion
Dateformat must be the same for all users even on different locale settings
Why not use the ISO 8601 standard for international use; at least each machine can understand the format regardless of locale. I also note that you want all your users to adopt the US standard which is the least understood (and the most illogical) of the candidate formats.
Date format by country - Wikipedia
The danger of allowing multiple input formats is that the dates will be accepted as dates, but not the date intended.
It is an international standard for representing dates.
https://en.wikipedia.org/wiki/ISO_8601In 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.
