Calculation of serial with date (restarting every year)
I'm a new user of FileMaker Pro and I'm trying to create this database to register my company projects but I'm starting to have some trouble generating this project code automaticaly.
What I want to do is create a serial number that combines the two digits of the year with a 3 digit project code. Something like this:
09001 (09 is the year, and 001 would be the serial number for project code).
I tried to use this formula, but happens that it dosen't restarts the counting if I change the year.
"Right( Year ( ProjectDate ); 2) & ProjectCode"
Is there a way to restart serial number generation accourding to the year of the date we set? Can you advise me on something?
Thank you very much.