AnsweredAssumed Answered

Scripting a New Year & Month for a New Record  ie: 2014_02

Question asked by tm9 on Feb 5, 2014
Latest reply on Feb 7, 2014 by beverly

Hi,

 

I have a table of months and would like to automatically enter a year & month in a field based on the previous record. I have created a script that does this.

 

The problem I am having is that for months (Jan - September; 01-09), the calculation does not enter the leading zero. I want it to enter 2014_02 but instead it will enter 2014_2.

 

I feel like this is a simple fix but I cannot think of the correct function.

 

Please help. Thanks!

 

I attached a picture of the script.

Outcomes