How to return the year

[nancy54]

I have a table with a TimeStamp field (the system Date()), and another field for the system autonumber ID. Using Right functions on both fields I have created a calculated field to return a year prefix and the last 3 digits of the ID. The problem is, instead of getting 18 (for the year), I am getting AM or PM. I have set the format to Short time, but still returns AM or PM.

Thanks in advance!
Nancy

 

[Ranman256]

Year(date())

 

[nancy54]

Thanks 26,
This did not work within the Right function...so I had to create another field (I called SystemYear) using Year(Date()) and concatenated that field with the ID field to get the an ID with a date prefix.