AnsweredAssumed Answered

Resetting Auto Serial Number Daily

Question asked by ChadBarnard on Jul 1, 2014
Latest reply on Jul 2, 2014 by philmodjunk

Title

Resetting Auto Serial Number Daily

Post

     Hey guys,

     I've found a bunch of related posts on the net, but they never seem to give the whole answer, so here it goes.

     My company uses a job number based on date and how many jobs are written up daily: 140701-001 (YYMMDD-jobs per day).  

     Here's what I have to make job number work:

     Let ( D = Get ( CurrentDate ) ; Right ( Year ( D ) ; 2 ) & Right ( "0" & Month ( D ) ; 2 ) & Right ( "0" & Day ( D ) ; 2 ) & "-" & Right( "00" & SerialNumber; 3) )

     The "SerialNumber" is an auto-enter Serial field.  My primary key field is separate.

     I need to have the last three digits reset daily.  Is a "Set Next Serial Value" script the trick?

     Thanks in advance for any help.

Outcomes