Numeric data with hour to %td

[Joan Marti]

Hi, I have a date variable in numeric format (without labels so I cannot decode it) of the format "18jul2019 08:11:41". I am trying to turn this into a %td date (i.e. taking out the hour:minute:second) but have not managed so far. Any help would be really appreciated.

Thank you very much!

[Maarten Buis]

Say that the variable is called datetime, then you would type

gen date = dofc(datetime)
format date %td

[Joan Marti]

Works perfectly, thank you!