/**
* 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;
}