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