And really, always use the YYYY-MM-DD format, as in the xkcd comic, above (or put the year, month, and day in separate columns, if you want).

How do you write the date in mm dd yyyy?

If you choose DateTime, you must enter the format for the Date/Time in the Date Format field using one of the following formats:yyyy-M-d — Example: 2013-6-23.M/d/yyyy — Example: 6/23/2013.d/M/yyyy — Example: 23/6/2013.dd. dd/MM/yyyy — Example: 23/06/2013.yyyy/M/d — Example: 2013/6/23.yyyy-MM-dd — Example: 2013-06-23.More items

What does it mean by MM DD YYYY format?

Acronym. Definition. MM/DD/YYYY. Two-Digit Month/Two-Digit Day/Four-Digit Year (e.g. 01/01/2000)