Add Hours and seconds using DATEADD()

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_TIMEZONE(DATEADD({set-date}, -7, ‘h’),‘America/Indiana/Indianapolis’), ‘M/D/YYYY hh:mm:ss’)

But I want to change the hour and the seconds from {set-date}.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.