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
Thanks in advance!
Nancy