AnsweredAssumed Answered

Calculation of serial with date (restarting every year)

Question asked by Socio.t on Jun 19, 2009
Latest reply on Jun 23, 2009 by Socio.t


Calculation of serial with date (restarting every year)


Hello everyone,


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.