AlanP Posted June 3, 2008 Share Posted June 3, 2008 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? Link to comment Share on other sites More sharing options...
jstaphse Posted June 4, 2008 Share Posted June 4, 2008 (edited) why not use Year (date) &"-"& incrementing field ? Edited June 4, 2008 by Guest painful typing on iPhone Link to comment Share on other sites More sharing options...
AlanP Posted June 4, 2008 Author Share Posted June 4, 2008 thank you! Link to comment Share on other sites More sharing options...
jstaphse Posted June 4, 2008 Share Posted June 4, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5805 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now