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.