Serial Number Calculation

[AlanP]

Currently we are using the default serial number configuration in a field (log number) so it looks like:

08-001 ('08' being the year prefix and '001' being the incrimental serial number)

Is there a way to turn this into a calculation so I can use a global field for the year prefix (that can be changed via our configuration layout) so the users won't have to modify this serial number field each year?

[jstaphse]

why not use

 Year (date) &"-"& incrementing field 

?

Edited June 4, 2008 by Guest
painful typing on iPhone

[AlanP]

thank you!

[jstaphse]

Actually now that I look at this, you would need to remove the first part of the year to get the "08".

Use this instead

  Right (Year (date);2) &"-"& incrementing field