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




      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.