topic Re: How do I add 00:10 to a DateTimeField in QlikView

How do I add 00:10 to a DateTimeField

helen_pip — Thu, 08 Nov 2018 08:27:29 GMT

Dear Qlikview User

In my script I have a date time field called

(TH.Session_End_Date+TH.Session_End_Time)

20/10/2018 08:00

I have an If statement where if all my conditions fail I would like my else statement to be (TH.Session_End_Date+TH.Session_End_Time) + 10 minutes

I have tried the following, but do not get the desired results

(TH.Session_End_Date+TH.Session_End_Time) + 0.00694444444444444

(TH.Session_End_Date+TH.Session_End_Time) + Interval(0.00694444444444444)

(TH.Session_End_Date+TH.Session_End_Time) + 00:10

Could someone kindly point me in the right direction so I can achieve this

Kind Regards

Helen

Zhandos_Shotan — Thu, 08 Nov 2018 08:54:22 GMT

Hi!

Make sure your strange datetime field really loaded as timestamp

Check it

Num([(TH.Session_End_Date+TH.Session_End_Time)]) = ?

And if its not numeric you need to perform some parsing operations.

tresB — Thu, 08 Nov 2018 08:57:40 GMT

To add 10 minutes to timestamp, try adding 10/24/60. Hence try like:

Your timestamp + 10/24/60