Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
: )
Interval(Timestamp#(enddatetime, 'DD / MM / YYYY hh : mm : ss TT')-Timestamp#(startdatetime, 'DD / MM / YYYY hh : mm : ss TT'), 'hh')
date2 - date1
then you can format in number tab EDIT: ops, didn't read is Qlik Sense
You want to add them or subtract them???
Interval(Timestamp#(enddatetime, 'DD / MM / YYYY hh : mm : ss TT')-Timestamp#(startdatetime, 'DD / MM / YYYY hh : mm : ss TT'), 'hh')
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:)
You're welcome.
regards
Marco