Discussion board where members can get started with Qlik Sense.
How to get no of days days between two columns
data is in below format in both columns
Go to Solution.
Can you provide your sample data or app?
floor(date1-date2) will give you difference in days
You can use interval()
Refer below link
How to Formatting DATE Field (YYYY-MM-DD :hh:mmS) into dates interval
I think, straight away you can do (Date2-Date1) if both the columns are having same date format.
That all depends on how you want to represent the difference i.e in Days or Hours
it is not giving correct values, tried as below
this is gving wrong values when tried below
when trying to do d1-d2 it is giving some abnormal value as below, can you please help on this
=Ceil(Interval(Date(Date1, 'MM/DD/YYYY hh:mm:ss') - Date(Date2, 'MM/DD/YYYY hh:mm:ss'), 'DD' ))