Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Few hours between two dates ?

Let me add the hours between two dates, two dates are formatted as follows :

DD / MM / YYY hh : mm : ss PM

How I can do it in the script?

Many thanks in advance.

: )

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

‌Interval(Timestamp#(enddatetime, 'DD / MM / YYYY hh : mm : ss TT')-Timestamp#(startdatetime, 'DD / MM / YYYY hh : mm : ss TT'), 'hh')

View solution in original post

5 Replies
maxgro
MVP
MVP

date2 - date1

then you can format in number tab          EDIT: ops, didn't read is Qlik Sense

sunny_talwar
MVP
MVP

You want to add them or subtract them???

MarcoWedel
MVP
MVP

‌Interval(Timestamp#(enddatetime, 'DD / MM / YYYY hh : mm : ss TT')-Timestamp#(startdatetime, 'DD / MM / YYYY hh : mm : ss TT'), 'hh')

Not applicable
Author

Thank you very much everyone for your contribution , i wanted is to add few hours between certain times ....

It works perfect with your contribution Marco.

Thousand thanks:)

MarcoWedel
MVP
MVP

You're welcome.

regards

Marco