Why CCYY-MM-DD is the Best Date Format
Date formats are not something that many people have any sort of opinion on, but it is something that I find very polarizing and I’ll explain why. The two date formats that I probably see most often are MM-DD-(CC)YY and DD-MM-(CC)YY, with the former being more prominent in the United States and the latter seeming to be the preferred format of European countries and elsewhere in the world. Maybe it aligns with use of the Metric system versus Imperial units, I’m not really certain. Either way, I think both options are terrible. First and foremost, they are terribly ambiguous. Without a definite indicator or a value higher than 12, the month and date could be interchangeable. Take today’s date, for example. September 12, 2018 as I will list it formally, could be represented as 09-12-2018 or 12-09-2018. Let’s not even get into the option of excluding the century from the year, as we all know of the headache that caused with Y2K. Without a clear context, those dates could alternatively ...