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



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.