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?

why not use

 Year (date) &"-"& incrementing field 

?

Edited June 4, 200817 yr by Guest
painful typing on iPhone

thank you!

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