AnsweredAssumed Answered

Auto-Generate Serial Number to change based on date

Question asked by nacrom on Sep 20, 2018
Latest reply on Sep 20, 2018 by philmodjunk

Hi Everyone,

 

just need a bit of guidance...

 

I have an Auto-Generate Serial Number field (Order Number), which the first 2 digits of the 6 digit number are the current fiscal year for my orders.

 

Is there a way to change the first 2 digits to the net year after a certain date say July 1.

 

for example my current order number range from 190001, 190002, 190003.....193006,193007,193008 ect ect

 

Come July 1 2019, i would like a script to change the first 2 digits to 20  so my order numbers would be 200001,200002, 200003, 202020,202021,202022 ect ect.

 

I was looking at "Set Next Serial Value" command for this, but not sure how to exactly script it to work.

can someone put me in the right direction.

 

Thank You

Outcomes