Serial number calculation
I know this might be easy, but I still need some help!
I am trying to create a calculated field which will be a serial number to the case in the database.
The serial number should look like this:
Ev - 12 - 001
With "Ev" being just text, "12" being a two digit year, and "001" being a serial.
So far I have got to this:
"Ev - " & Year(Get(CurrentDate)) & EvID --> But this returns a 4 digit year...
EvID is a Serial Number field being auto created on data entry, but invisible from layout.