AnsweredAssumed Answered

help with calculations for year/resetting counter

Question asked by Smash209 on Mar 8, 2009
Latest reply on Mar 10, 2009 by ninja

Title

help with calculations for year/resetting counter

Post

I'm trying to setup a log of all my various rolls of film.  The catch is I want the unquie number to start with the last two digits of the year and then increment by 1 until the year changes.  So 2006 has 3 rolls (0601, 0602, 0603).  Now 2007 has 2 rolls (0701, 0702).

 

I was able to extract the last two digits of the year using the Right function, but I cannot figure how to make a counter that resets each year.

 

Outcomes