Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.

: )

1 Solution

Accepted Solutions
MarcoWedel

‌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

You want to add them or subtract them???

MarcoWedel

‌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

You're welcome.

regards

Marco