Script to convert date to another time zone and add days to the date using single saved search formula

search.createColumn({
name: "formuladate",
formula: "CAST(TO_DATE(To_Char({today}+5, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS TIMESTAMP) AT TIME ZONE 'America/New_York'",
label: "Formula (Date)"
})

Leave a comment

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