11-24-2015 10:54 AM
I am trying to save the numeric year as a column based off of a data column.
In a datastep I have
Year = year(Project_Start);
Oddly the year returns blank. In the log there is this line:
NOTE: Invalid argument to function YEAR(1772409600) at line 80 column 9.
11-24-2015 11:01 AM - edited 11-24-2015 11:11 AM
Most likely you are dealing with a date-time value instead of date. Try this:
Year = year(datepart(Project_Start));
Need further help from the community? Please ask a new question.