AnsweredAssumed Answered

Month Format

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

Title

Month Format

Post

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???

Thanks

jbrad

 

 

Outcomes