If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi I have a question,
I ve been trying these for weeks but without help.
I have a table with two fields: DATE_A , DATE_B
The measure for DATE_A is: DD/MM/YYYY and Hours (e.g. 12/06/2019 14:00:00)
The measure for DATE_B is: DD/MM/YYYY (e.g 14/06/2019)
My need is to calculate the days between these field without considering the hours inside the calculation.
I want the system to don't consider the hours inside the calculation.
31/05/2019 15:01:19 - 01/06/2019 = 0,37 days [ACTUAL]
31/05/2019 - 01/06/2019 = 1,00 days [EXPECTED NEED]
I want to do this because
Could you please give me the right formula for this calculation?
Thank you in advance.
use this in Script:
Interval(Num(DateB)-Floor(Timestamp#(DateA_Mod,'DD/MM/YYYY h:mm:ss')),'DD') as Diff,
Date(Floor(Timestamp#(DateA_Mod,'DD/MM/YYYY h:mm:ss'))) as DateA