Date transformation

[Collin James]

Hello,

I have a date that is showing up like 16may2016 00:00:00 in my data (shown below using dataex). Is there a way to transform this so that I could just have year and month like this: 2020m1 2020m2 etc.

Thanks -CJ

[Collin James]

Oops here it is

* Example generated by -dataex-. For more info, type help dataex
clear
input double plcmnt_entry_dt
1.5942528e+12
1.6153344e+12
 1.627776e+12
1.6462656e+12
1.6491168e+12
1.6716672e+12
1.7279136e+12
1.7502048e+12
 1.766016e+12
1.5907104e+12
1.5900192e+12
1.5907104e+12
1.7762112e+12
  1.77984e+12
1.5907104e+12
1.7740512e+12
1.7743104e+12
1.5900192e+12
1.5907104e+12
1.5900192e+12
1.7741376e+12
1.6749504e+12
1.5783552e+12
1.5753312e+12
1.5795648e+12
1.7362944e+12
1.7458848e+12
1.6981056e+12
1.6985376e+12
1.7000064e+12
 1.707696e+12
1.7095104e+12
1.7196192e+12
1.7411328e+12
1.7430336e+12
1.7623872e+12
 1.772064e+12
1.7749152e+12
1.7883072e+12
1.6071264e+12
1.6129152e+12
1.6158528e+12
1.6214688e+12
1.6764192e+12
1.6291584e+12
1.6435008e+12
 1.590624e+12
 1.739664e+12
1.8331488e+12
1.6555968e+12
1.7312832e+12
1.7368992e+12
1.8652032e+12
 1.658448e+12
1.7613504e+12
1.7718912e+12
1.7740512e+12
1.7743104e+12
1.8480096e+12
1.8794592e+12
1.8802368e+12
 1.902096e+12
1.5579648e+12
 1.562112e+12
1.5631488e+12
1.5937344e+12
1.5589152e+12
1.5899328e+12
1.5451776e+12
1.5602112e+12
1.6009056e+12
1.8287424e+12
 1.921968e+12
1.9224864e+12
1.9239552e+12
1.9247328e+12
1.9262016e+12
1.9287072e+12
1.9304352e+12
1.9319904e+12
1.5952032e+12
 1.595808e+12
1.5964992e+12
1.5970176e+12
 1.601856e+12
1.6568928e+12
1.6661376e+12
1.6685568e+12
1.6737408e+12
1.6767648e+12
1.7009568e+12
1.6225056e+12
1.6237152e+12
1.5658272e+12
 1.569888e+12
1.5934752e+12
 1.607904e+12
1.5957216e+12
1.6000416e+12
1.5683328e+12
end
format %tc plcmnt_entry_dt

[Nick Cox]

Naturally. See

help datetime

to learn about the use of

mofd(dofc())

to extract a monthly date, or see the numdate package on SSC for dedicated utilities.