Dear Stata users,

I'm using the Stata 17 MP and want to manipulate dates with different digits (see below).

In the first row, for instance, I have "9012002" (7 digits), meaning 09dec2002. In the third row, I have "29052000" (8 digits), which is 29mai2000.

I tried to transform the dt_admissao variables in many ways, but unfortunately, I could not obtain operationalizable dates. Could you help me solve my problem?

* Example generated by -dataex-. For more info, type help dataex
clear
input str8 dt_admissao
"9012002"
"1022002"
"29052000"
"17122001"
"1022002"
"1032000"
"1082001"
"1092002"
"1081995"
"1032001"
end