AnsweredAssumed Answered

Month Format

Question asked by jbrad1968 on Feb 5, 2012
Latest reply on Feb 9, 2012 by jbrad1968


Month Format


How can i force this calculation to put a zero in front of the months that are single digit????


"GC" &  Right ( Year ( CurrentDate ) ; 2 )  & "-" & Month ( CurrentDate )  & "-" & Incrementer


This calculation returns GC12-2-001 but i need it to return the -2- to -02- representing the month of Feb.


Also my Incrementer field is an auto entry number field that i need to reset to 001 on the first day each month. Does it need to be a script that runs on the first day of the month or a calculation in the Incrementer field??? Which ever can you give an example of???