Editing dates

[man singh]

Hello!
I have a dataset that has dates in this format--

200392

70391

301192

Could someone please help me with changing the format of this?

[Nick Cox]

Please follow https://www.statalist.org/forums/help#stata and use dataex to give a good data example.

This may help:

clear
input bad_date
200392
70391
301192
end 

gen better_date = cond(bad_date < 1e5, "0", "") + strofreal(bad_date)

gen good_date = daily(better_date, "DMY", 2025)

format good_date %td 

list 

     +---------------------------------+
     | bad_date   better~e   good_date |
     |---------------------------------|
  1. |   200392     200392   20mar1992 |
  2. |    70391     070391   07mar1991 |
  3. |   301192     301192   30nov1992 |
     +---------------------------------+