Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

How do I add 00:10 to a DateTimeField

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



2 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

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
MVP
MVP

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

Your timestamp + 10/24/60