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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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)