Dear all,

Sorry for basic question. I would like to translate the following date into Stata date format.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 dscd str8 date
"ID:AAL" "10101990"
"ID:AAL" "10111990"
"ID:AAL" "1011990" 
"ID:AAL" "10121990"
"ID:AAL" "10151990"
"ID:AAL" "10161990"
"ID:AAL" "10171990"
"ID:AAL" "10181990"
"ID:AAL" "10191990"
"ID:AAL" "1021990" 
"ID:AAL" "10221990"
"ID:AAL" "10231990"
"ID:AAL" "10241990"
"ID:AAL" "1031990" 
"ID:AAL" "1041990" 
"ID:AAL" "1051990" 
"ID:AAL" "1081990" 
"ID:AAL" "1091990" 
"ID:AAL" "1101990" 
"ID:AAL" "11101989"
"ID:AAL" "1111990" 
"ID:AAL" "11131989"
"ID:AAL" "11141989"
"ID:AAL" "11151989"
"ID:AAL" "11161989"
"ID:AAL" "11171989"
"ID:AAL" "111990"  
"ID:AAL" "11201989"
"ID:AAL" "11211989"
"ID:AAL" "1121990" 
end

I tried both:
Code:
 gen date2 = date(date, "MDY")
format date2 %td
and
Code:
numdate daily date3 = date, pattern(MDY)
But both treat 1041990 (October 4 1990) and some others as missing. Could you please help? Thank you.



Best regards,