Stata can work with dates such as 21nov2006, with times such as 13:42:02.213, and with dates and times such as 21nov2006 13:42:02.213. You can write these dates and times however you wish, such as 11/21/2006, November 21, 2006, and 1:42 p.m.
How to change the format of date in Stata?
To convert such dates to Stata dates, use the mdy function. It takes three numeric arguments: the month, day and year to be converted.
What is * MDY date format?
For English speakers, MDY (mmmm-dd-yyyy) (example: April 9, 2019) is used by many English-language publications and media company products as well as the majority of government documents written in English. For French and English speakers, DMY (dd-mmmm-yyyy) is used (example: 9 April 2019/le 9 avril 2019).