Auto #, restarting series each day

Question

We have an auto # like this: PRO-{YY}{MM}{DD}-{00}

The 00 continues sequentially, but we want to have the 00 restart each day. So, today we will receive records with these #.s:

PRO-160510-01

PRO-160510-02

PRO-160510-03

PRO-160510-04

Tomorrow we want the number to restart in order to receive records with these #.s:

PRO-160511-01

PRO-160511-02

PRO-160511-03

How can we have the numbering series restart each day?

Karthikeyan Chandran · Answer

Hi,

This can be done via Apex Code.

Please post this question in one of the developer forums for a quick response

Data Management