I’m trying to create an automatic file numbering scheme for my project list and file list. I’ve read some of the other posts on this but can’t get my specific need. I’d like the filing scheme to be:
year (last 2 digits) + 3 digit sequential number: so 20-001, 20-002, etc.
I figured out how to pull out the string value for the year from current date (i.e. “20”) and I’ve figured out how to sequentially number entries. But I can’t get the two together. For example, when 2021 starts, I want the numbering to reset to 001. Is there anyway to do that?