Capture the year of a date 1

[dulla]

hello i am trying to base the value of a field on date which is entered by the user. so if 'date_received' is entered as 1/23/03, i would like the value of the field 'past1' to equal 2001, 'past2' to 2002, etc. is there a way to separate out the year to execute this calculation? thanks.

ameen

 

[cP6uH]

past1 = Format(date_received, "yyyy&quot

that will take out year out of the date_received and put it in past1 variable.

Dragan