AnsweredAssumed Answered

New Record numbering problem

Question asked by RobIreland on Feb 14, 2009
Latest reply on Feb 16, 2009 by RobIreland


New Record numbering problem




I have a client that wants a very particular type of numbering for all new records in their database.


It needs to be:  PS-2009-02-followed by auto numbering of all records created in Feb. 2009 (incremented by 1). In March, the increment would start back at 1.


I've been playing around for a day now, and I can't seem to get it to work.  The closest that I've come is getting the PS-Year-(month is showing as just a single digit 2, it needs to be 02).


Here is the calculated field details I've been using.  Any help you could give me to point me in the right direction would be extremely helpful.  Thanks!


Upper ( Product Description ) &   (Year ( Date Created )  &  Month ( Date Created ) )

Note: Product Description is being used to hold the letters PS in it.