Hi all,

I have a large set of string variables (too large to encode) that contain dates and specific times in the following manner:
09SEP19:09:00:00
I would like to convert it to dates using either
gen new_date_var = date(string_var, "DMY###")
gen new_date_var = clock(string_var, "DMY#hms")

However none of these work apparently because of the : between the Year and the Time (---19:09---) and therefore the new_date_var generates only missing values.
I also tried to use multiple # to account for the additional : but it is not working.

I would highly appreciate any help =)

Thank you for your time!