12 Replies Latest reply on Jan 18, 2016 6:56 AM by jurodj

    Auto reset autoserial counter

    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?