How to convert stringdate to date?

[Phuc Nguyen]

Dear experts,

I am trying to convert string-type datatype to date type
First I tried to force the date column of csv file to numeric but it turns out that all cells are missing,

Therefore I input the data to the Stata dta and have a sample as below

* Example generated by -dataex-. For more info, type help dataex
clear
input str18 country str10 date str20 id
"Argentina" "2021-08-31" "Argentina_1"
"Argentina" "2021-09-01" "Argentina_1"
"Argentina" "2021-09-02" "Argentina_1"
"Argentina" "2021-09-03" "Argentina_1"
"Argentina" "2021-09-06" "Argentina_1"
"Argentina" "2021-09-07" "Argentina_1"
"Argentina" "2021-09-08" "Argentina_1"
"Argentina" "2021-09-09" "Argentina_1"
"Argentina" "2021-09-10" "Argentina_1"
end

I have tried a couple of approaches around following some topics here but there is nothing works so far.

generate numdate = date(date, "MDY")
format numdate %td

generate numdate1 = date(date, "MDY")

Many thanks and best regards,

[Nick Cox]

Your dates are YMD not MDY.

[Øyvind Snilsberg]

the date format is year-month-day,

gen numdate = date(date, "YMD")

[Phuc Nguyen]

Dear Nick Cox and @Øyvind Snilsberg, I got it now, problem solved

Thank you