date_manipulation

[mauri0623]

I have a birthdate such as 01SEP60:00:00:00. 

Length = 8

Format datetime16.

Informat anydtdtm40.

I want to get the year of this string. I tried birth_year = year(input(birthdate,anydtdte20.)); I did not get any erro but every birth_year came out as missing.

Thank you!

[yabwon · Accepted solution]

b_y =  year(datepart(birthdate));

?

Bart

[Tom]

So you don't have a DATE (number of days).  You have a DATETIME (number of seconds).

The YEAR() function needs a DATE value.  You can convert a DATETIME value to a DATE value by using the DATEPART() function.