How to convert numeric to date in Stata?
Converting Numbers to Dates
To convert such dates to Stata dates, use the mdy function. It takes three numeric arguments: the month, day and year to be converted.
How to convert date string to date Stata?
You can convert dates stored as strings to Stata dates by using the string-to-numeric conversion functions; see Converting dates stored as strings to Stata dates. You can make Stata dates readable by placing the appropriate %fmt on the numeric variable; see Formatting Stata dates for display.