3 Replies Latest reply on Feb 7, 2014 4:48 AM by beverly

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

    tm9

      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.