Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use the code below to create the calculated variable.  Remember this ignores year!  

On Expression tab:

Exclude Previous Years Approach:

Modify the picklist options to include:

...

function 12 = Previous year, 13 = Missing date

 function main() {

   if(isNull(V1)) {    // check to make sure the date field exists

   return 12;

       return 13;   

   } else {

          var myMonth = V1.getMonth();   

      var myYear = V1.getYear();     

      if (myYear <= 2015) {          // previous year = 2015, replace as appropriate

           return 12;     

     } else {

           return myMonth;

     }   

 }

}

On the Pick List tab:

List months 0 to 12 (e.g., 0 = January, etc.; 12="Previous Year"; 13 = "Missing Date")

 

 

Exclude Previous Years Approach:

Modify the picklist options to include: 12 = Previous year, 13 = Missing date

...

Alternate method that ignores the year:

In this example, don't need a pick list option for 12/Previous Year

function main() {

   if (isNull(v1V1)) {           // check to make sure the date field exists

   return 13;   

   } else {

          var myMonth = V1.getMonth();

      var myYear = V1.getYear();     

      if (myYear <= 2015) {          // previous year = 2015, replace as appropriate

           return 12;     

     } else {

           return myMonth;

     }   

     return myMonth;

}

}