Resetting Auto Serial Number Daily
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.