Discussion Board for collaboration on QlikView Scripting.
Let me add the hours between two dates, two dates are formatted as follows :DD / MM / YYY hh : mm : ss PMHow I can do it in the script?Many thanks in advance.: )
Go to Solution.
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???
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:)