Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
To add 10 minutes to timestamp, try adding 10/24/60. Hence try like:
Your timestamp + 10/24/60