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.