Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Add hours to date

I have a date field that shows the date in this format - 22/09/2021

I need to add 5 hours and 30 minutes to my date.

My resultant date should look like the same, just I need to add 5 hours and 30 minutes to 22/09/2021.

1 Reply
Thiago_Justen_

Could be this:

Timestamp((YourTimeStamp + Timestamp(MakeTime(5,30))),'DD/MM/YYYY hh.mm.ss')

Or

TIMESTAMP(YourFieldName+Time#('05:30:00','hh:mm:ss'))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago