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.