AnsweredAssumed Answered

Serial Number Generation

Question asked by tmilas on Feb 10, 2012
Latest reply on Feb 13, 2012 by ariley

My Fellow FMers,

 

I've been mid level guy. However this time I stumbled on something and it seems can't go forward.

Here is my dilemma:


I created DB with records of products/items.

My company has the strict rules for serial numbers:

 

1VAL12B123ADVAC

 

1VAL is always there, 12 means a year of manufacture, B means a second month, 123 is an actual serial number. ADVAC is a type of product.

12 - year can be obtained from "date created" field (auto-enter today's date), so is the month B from the date created (calculation).

Serial number starts for new month at 100, still OK and sequential number is done by adding 1.

 

My problem is that I don't know how to do a test if for SN it is next number or it should be 100 if the month is new.

 

Any suggestions?

 

Much obliged (in advance).

 

Tom

Outcomes