YEAR

[Guest]

This code returns the Month.
I need another column to return the year but there is not a YEARNAME
function...
IIf([TR_CLOSEDATE] Is Null,Null,MonthName(Month([TR_CLOSEDATE]),True))

Any suggestions

 

[RBear3]

Year([TR_CLOSEDATE])

Will return the year.