Is 12-11-10 read as December 11, 2010 or November 12, 2010 or October 11, 2012? The answer may be different, depending on where you live. When the date is displayed in numeric format, it can be interpreted in different ways, which would impact the way you use and understand the data.
In this Nudge, we introduce the ISO Date format that is highly recommended to avoid this confusion. Being consistent will help you overcome this obstacle.
The international format defined by ISO 8601 is a standard and especially helpful if you are working in group or collaborating internationally:
- YYYY is for the year, use all in digits/numbers
- MM is for the month, use in digits/numbers, starts 01 (Jan) to 12 (Dec)
- DD is for the date, use in digits/numbers, starts 01 to 31
For example, May 25, 2021 is represented as 2021-05-25.
🛈 If you need to include time, visit this page for more information.