I have an organization that likes to have at least a 4 digit serial number. So their first record of the year is #1. They would like it to appear as 2019-0001 When I concatenate the year (2019) with the next serial value I get 2019-1 Is there a way to pad the first zeros?
I also need a way to reset that serial number at the end of the year automatically back to 1.
Thanks for any help