Extracting year from date variable

[Tariq Abdullah]

Hello,

My date variable looks like the following. I have tried using this command but it gives me a mismatch error.

May I get the correct way to extract year from my date variable ?

I used this code below to extract year and got the error

gen year=year(date) 
type mismatch
r(109);

dataex date

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input str10 date
"2000-11-29"
"2000-11-29"
"2000-12-01"
"2000-11-29"
"2000-12-01"
"2000-12-01"
end

[Maxence Morlet]

g year=substr(date,1,4)

destring year, replace

[Tariq Abdullah]

Thanks for your kind and quick response! I appreciate it !

I have found another way to do it, in case if anyone wants to explore. But, Mr. Morlet's option is easier and faster.

gen sd3_date = date(date, "YMD")
format sd3_date %td
list sd3_date
gen year=year(sd3_date)

[Nick Cox]

Both solutions can be telescoped.

gen year = real(substr(date,1,4))  

gen year2 = year(daily(date, "YMD"))

[Tariq Abdullah]

Both solutions can be telescoped.

gen year = real(substr(date,1,4))

gen year2 = year(daily(date, "YMD"))

Thanks for helping me me deep dive into this! appreciate the kind response !