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