Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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