My end user wants a unique ID that consists of “YY” + “DDD” + 12-digit consecutive number that resets to 1 each day - so it would be:
000000000001
000000000002
000000000003…
The date parts are cake, but the consecutive number is throwing me for a loo...