Best Practice: For date, always include four digit year and use numbers for months. For example, the date format yyyy-mm-dd would appear as 2011-03-15 (March 15, 2011). If Julian day is used, make sure the year field is also supplied.
The United States is one of the few countries that use “mm-dd-yyyy” as their date format–which is very very unique! The day is written first and the year last in most countries (dd-mm-yyyy) and some nations, such as Iran, Korea, and China, write the year first and the day last (yyyy-mm-dd).
Date Format TypesFormatDate orderDescription1MM/DD/YYMonth-Day-Year with leading zeros (02/17/2009)2DD/MM/YYDay-Month-Year with leading zeros (17/02/2009)3YY/MM/DDYear-Month-Day with leading zeros (2009/02/17)4Month D, YrMonth name-Day-Year with no leading zeros (February 17, 2009)24 more rows
Is it mm-dd-yyyy or dd-mm-yyyy?
National standard format is yyyy-mm-dd, casually many people use d/m yyyy or d/m -yy.