How do I add 00:10 to a DateTimeField

[helen_pip]

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]

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.

[tresesco]

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

Your timestamp + 10/24/60