Retrieve a single variable value in the format YYYYMMM and write it to a text box as MM YYYY

Example:
We have a query variable (prompt) on a date, when the user selects a value is it passed to the story as
2025009
We are using the fiscal year so month 009 refers to December.

We want a text box to display ‘December 2025’

var monthMap = {
    “001”: “April”,
    “002”: “May”,
    “003”: “June”,
    “004”: “July”,
    “005”: “August”,
    “006”: “September”,
    “007”: “October”,
    “008”: “November”,
    “009”: “December”,
    “010”: “January”,
    “011”: “February”,
    “012”: “March”
};
var Value=cast(Type.SingleVariableValue,Table_2.getDataSource().getVariableValues(“VARIABLE_NAME”)[0]).value;
var MONTH_NUMBER = Value.substr(4,7);
var YEAR= Value.substr(0,4);
txt_month.applyText(monthMap[MONTH_NUMBER]+” “+YEAR);

var monthMap = {
    "001": "April",
    "002": "May",
    "003": "June",
    "004": "July",
    "005": "August",
    "006": "September",
    "007": "October",
    "008": "November",
    "009": "December",
    "010": "January",
    "011": "February",
    "012": "March"
};
var Value=cast(Type.SingleVariableValue,Table_2.getDataSource().getVariableValues("VARIABLE_NAME")[0]).value;
var MONTH_NUMBER = Value.substr(4,7);
var YEAR= Value.substr(0,4);
txt_box.applyText(monthMap[MONTH_NUMBER]+" "+YEAR);

Code language: JavaScript (javascript)

bACK