You can't mix data types in the results. "Evergreen" is a string type. [End Date] presumably is a date type. STR([End Date]) would fix this, but you might not like the result. --Shawn
What is the work around ? I have one date like "1/2/2223". The management wants me to populate "Evergreen" for this date. What is the best work around ?
1 of 1 people found this helpful
It works like this:
IF STR(Year([END Date]))= "2222" Then "Evergreen"
ELSE STR([End Date (copy 2)])