Converting string to date: missing values generated

[Brian Coleman]

New to STATA and have searched responses to others with this issue but can't resolve my own instance. I have been able to convert strings to dates in other projects but this one returns "missing values generated." Any help would be appreciated.


gen date2 = date(date,"MDY")
(15 missing values generated)

* Example generated by -dataex-. To install: ssc install dataex
clear
input str7 date
"1/1/18" 
"2/1/18" 
"3/1/18" 
"4/1/18" 
"5/1/18" 
"6/1/18" 
"7/1/18" 
"8/1/18" 
"9/1/18" 
"10/1/18"
"11/1/18"
"12/1/18"
"1/1/19" 
"2/1/19" 
"3/1/19" 
end

* Example generated by -dataex-. To install: ssc install dataex
clear
input float date2
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
end

[Nick Cox]

You need to specify 20Y in your call. See

help datetime

[Brian Coleman]

Thank you.