Converting date to integer 0 and 1

[sungwook kim]

Hello,

I have an int variable (not string; format %td) that presents date as "01jan1900". As this is not what I wanted and miscoded, I would like to convert this into integers such as 0,1,2,3. The codes I tried are as follows but they didn't work.

replace HVPN_E14_C64 = 0 if HVPN_E14_C64 =="31dec1899" type mismatch

gen  HVPN_E14_C64_real =real(HVPN_E14_C64)
type mismatch

replace HVPN_E14_C64 = 0 if HVPN_E14_C64 ==31dec1899
31dec1899 invalid name

Your help will be appreciated. Thank you!

Kind regards,
Kim

[Rich Goldstein]

you want the "td()" function; see

h td()
or, more generally,
h datetime

[sungwook kim]

Hello I found the answer from other post.

gen HVPN_E14_C64_1 = real(string(mofd(HVPN_E14_C64), "%tmCYN"))

Thanks,