topic Time logic help in QlikView

Time logic help

abhaysingh — Tue, 15 Dec 2015 07:43:19 GMT

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?

marcus_sommer — Tue, 15 Dec 2015 07:51:48 GMT

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

- Marcus

avinashelite — Tue, 15 Dec 2015 07:53:04 GMT

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)