topic Re: Changing a timestamp in QlikView

Changing a timestamp

Wed, 25 Apr 2012 09:57:12 GMT

Hi I have a very simple question here. I have a time variable here t=now(); And I want to get a time 15 minutes before that and store it in another variable. How can I do this?

Re: Changing a timestamp

christophebrault — Wed, 25 Apr 2012 10:21:49 GMT

hi,

You can use this in your other variable :

=timestamp(now()-maketime(00,15,00))

For more information on Time in Qlikview you can read : http://qlikviewnotes.blogspot.fr/2011/10/correct-time-arithmetic.html

Re: Changing a timestamp

Anonymous — Wed, 25 Apr 2012 10:23:15 GMT

LET NewTime=timestamp (now()-1/96)

Changing a timestamp

Wed, 25 Apr 2012 10:24:50 GMT

Hi,

t2=date(now()-.0104167)

should do the trick

for date arythmetics

now() - 1 is yesterday same hour

now() - (1/24) is now minus one hour

now() - ((1/24)/4) is now minus 15 minutes

Re: Changing a timestamp

Wed, 25 Apr 2012 11:21:37 GMT

just try

=date(now()-Time#(15,'mm'),'DD.MM.YYYY hh:mm')

Changing a timestamp

Thu, 26 Apr 2012 03:06:17 GMT

Hi guys,

Thank you for your prompt reply. Your answers are all correct. Appreciate the help you all give me:)

Regards,

Xue Bin