Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Subtract Hours from date

I have a date field [INDT] and I want to subtract 5 hours from it. Please help me.

My [INDT] is in the below format 

risabhroy_03_0-1636528714218.png

11 - Month

1 - Date

2021 - Year

1 Solution

Accepted Solutions
tresesco
MVP
MVP

[INDT] - 5/24 will give you timestamp reduced by 5 hours. Then you can format the output using any formatting function like timestamp().

View solution in original post

1 Reply
tresesco
MVP
MVP

[INDT] - 5/24 will give you timestamp reduced by 5 hours. Then you can format the output using any formatting function like timestamp().