Incrementing last digit in a custom serial number

[cherrydee]

Hi, i am trying to increment the last digit of a custom field. An example is 2018-08-001. The code i am using is left(a1,10) & 1 + right(a1,1)
I am having issues when it reaches 2018-08-009. It becomes 0010. Also probable future problem is whenb it reaches 2018-08-999.
Any help is appreciated. Thank you!

 

[JoeMo]

This works like a charm! Tho i removed the for loop since i put the nextvalue in msgbox and it won't stop. Lol. Anyway, not sure what the for loop is for.

Glad it works for you, just added the for loop to demonstrate the output.

 

[Rick Rothstein]

Hi, your code works great! But how can i adjust it when it reaches thousands like 2018-08-1000? Cause I'm not really sure how long the records would be.

Once the last 3 digits reach 999, the roll-over turns the 999 to 000 and adds 1 to the two digit number. So, once it reached this...

2018-08-999

then next number would be this...

2018-09-000

What I wasn't sure of is if 000 would be the correct roll-over number or should 000 be skipped and 001 be the number following 999 (the reason I wondered about this is because apparently, your starting number is 2018-08-001, not 2018-08-000).