Help

Add Hours and seconds using DATEADD()

Topic Labels: Dates & Timezones
835 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Stefan_Welsh
5 - Automation Enthusiast
5 - Automation Enthusiast

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}.

0 Replies 0