Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

124psu
Contributor

time stamp subtract hours

I want to subtract 4 hours from the now() function to show the EST time zone. 

=timestamp(now() - time(4))

This actually does nothing and gives me the same thing as = now().

Anyone have any tips/ideas on how to simply subtract 4 from the now() function?

Labels (3)
1 Solution

Accepted Solutions
salezian
Contributor

Re: time stamp subtract hours

Hi

Did you try this:

=Timestamp(num(now())-4/24)

KR

Marcin.

2 Replies
salezian
Contributor

Re: time stamp subtract hours

Hi

Did you try this:

=Timestamp(num(now())-4/24)

KR

Marcin.

124psu
Contributor

Re: time stamp subtract hours

Thanks very much. Didn't realize I had to divide by 24.