Get today’s date in a different timezone using the search

/**
 * Function to get todays date in other timezone
 * @returns {Date}
 */
Function getDateToday() {
    let todaydate;
    let customrecord_jj_windchill_api_config_recSearchObj = search.create({
        type: "customrecord_jj_windchill_api_config_rec",
        filters:
            [],
        columns:
            [
                search.createColumn({name: "internalid", label: "Internal ID"}),
                search.createColumn({
                    name: "formulatext",
                    formula: "TO_CHAR(CAST(TO_DATE(To_Char({today}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS TIMESTAMP) AT TIME ZONE 'Europe/Amsterdam','MM/DD/YYYY')",
                    label: "Formula (Text)"
                })
            ]
    });
    let searchResultCount = customrecord_jj_windchill_api_config_recSearchObj.runPaged().count;
    log.debug("customrecord_jj_windchill_api_config_recSearchObj result count", searchResultCount);
    customrecord_jj_windchill_api_config_recSearchObj.run().each(function (result) {
        // .run().each has a limit of 4,000 results
        todaydate = result.getValue({
            name: "formulatext",
            formula: "TO_CHAR(CAST(TO_DATE(To_Char({today}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS TIMESTAMP) AT TIME ZONE 'Europe/Amsterdam','MM/DD/YYYY')",
            label: "Formula (Text)"
        });
        // return true;
    });
    todaydate = new Date(todaydate);
    return todaydate;
}

Leave a comment

Your email address will not be published. Required fields are marked *