Trying to change hours and seconds using this formula.
DATETIME_FORMAT(SET_TIMEZONE(DATEADD(DATEADD({set-date}, 1, ‘s’){set-date}, -7, ‘h’) ‘America/Indiana/Indianapolis’), ‘M/D/YYYY hh:mm:ss’)
I can get one to work like this
DATETIME_FORMAT(SET_TIME...