Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Time logic help

Hi all,

I have small issue..

i have timestamp like 10/10/2015 11:00:00 PM

i want to add Hour into it like suppose 17 hour in to it

how i can achieve it?

1 Solution

Accepted Solutions
avinashelite

If it's a field containing a numeric number of hours:

timestamp(Date + NumberOfHours/24)

Or if you're adding a specific number of hours:

timestamp(Date + 50/24)

View solution in original post

2 Replies
marcus_sommer

Try: timestamp(YourTimestamp + (1/24*17), 'YourFormat')

- Marcus

avinashelite

If it's a field containing a numeric number of hours:

timestamp(Date + NumberOfHours/24)

Or if you're adding a specific number of hours:

timestamp(Date + 50/24)