Converting to month-yr

[Collin James]

Hello,

I have tried using a few commands and haven't had luck--I think I am just confused. How do I turn dates that look like "01jan2020" into month-yr dates like "2020m1"? Data below. TIA--CJ

* Example generated by -dataex-. For more info, type help dataex
clear
input double rmvl_entry_dt
1.5900192e+12
1.6153344e+12
1.6153344e+12
1.6153344e+12
1.6153344e+12
end
format %tc rmvl_entry_dt

[Jared Greathouse]

Is this the solution you were hoping for?

* Example generated by -dataex-. For more info, type help dataex
clear *
input double rmvl_entry_dt
1.5900192e+12
1.6153344e+12
1.6153344e+12
1.6153344e+12
1.6153344e+12
end
format %tc rmvl_entry_dt
cls

gen mnth = mofd(dofc(rmvl_entry_dt))

br

[Nick Cox]

I think Collin needs mofd(dofc())

[Jared Greathouse]

Indeed, I'd edited it before I refreshed the page Nick Cox.

Luckily for me, I usually work with normal stuff like days, months, years and so on, but once you get into times and milliseconds, oh my Lord does Stata get complicated sometimes.

[Collin James]

Thank you both!