AnsweredAssumed Answered

Padded serial number

Question asked by user1081 on Jan 1, 2019
Latest reply on Jan 3, 2019 by eric_evers

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

Bill Bélanger

Outcomes