This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Solved my own issue— seems like any time you want to use a date function like TODAY() in a formula, you have to wrap it in DATETIME_FORMAT(SET_TIMEZONE({Your dynamic date or date function}, ‘Your_timezone_string’), ‘format-that-works-for-you’), then ...
Can confirm, SET_TIMEZONE() only works at all in the context of the DATETIME_FORMAT() function, and even there it only changes the way the dates are displayed, not the underlying datetime. If using a dynamic date function like TODAY() in a formula th...