...
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;
}
}