AnsweredAssumed Answered

Auto reset autoserial counter

Question asked by jurodj on Jan 14, 2016
Latest reply on Jan 18, 2016 by jurodj

I have a field named JobID(text) which is in the format YYYYMMDD_## and IDCounter(Num) which is an auto sequential number for the last two ## digits inserted in the JobID field.

As an example:

On Jan 14, 2016 JobID goes like this:

20160114_01

20160114_02

20160114_03..., etc...

Next day it goes like:

20160115_04

20160115_05

20160115_06

 

What I want to achieve is that each new day the ID counter reset to 0 (or 1) and begin a new the new day as 01,02, 03,etc..

As an example:

On Jan 14, 2016 JobID goes like this:

20160114_01

20160114_02

20160114_03..., etc...

 

Next day Jan 15, 2016:

20160115_01

20160115_02

20160115_03..., etc...

 

Can anyone help me?

Outcomes