AnsweredAssumed Answered

Serial number calculation

Question asked by MilutinPetrovic on Oct 27, 2012
Latest reply on Oct 29, 2012 by MilutinPetrovic


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.

Any ideas?