resetting automatic serial number

[Capt JB]

Guys,

 

I've no programming background, so I am asking for help  . 

 

I have a text field with an automated serial number of three digits by increment of 1. This serial is part of an ID number that includes the current date.

I am trying to have this serial returned to 001 at midnight, meaning that every single day the serial starts at 001 up to maximum of 999.

My problem is I cannot have the serial reset to 001, unless I do it manually.

Any help will be very much appreciated

 

If there is a link available so I can learn basic programming instead of sucking knowledge, it will be very much appreciated too, and I would feel better..  TIA

 

 

[Wim Decorte]

What formula have you tried?  We can start with that.