topic Date difference in QlikView

Date difference

upaliwije — Sun, 08 Feb 2015 11:10:11 GMT

I have in my data module two dates

Begin_Date

EG 01-JAN-2014'

01-FEB-2014'

01-MAR-2014'

END_DATE

EG 31-JUL-2014'

31-JAN-2015'

25-JAN- 2014

How can I calculate the difference between two dates in days

Pls help

Anonymous — Sun, 08 Feb 2015 11:21:46 GMT

Try something like :

=date#('31-JUL-2014','DD-MMM-YYY') - date#('01-JAN-2014','DD-MMM-YYY')

upaliwije — Sun, 08 Feb 2015 11:57:00 GMT

Thanks

But it is not working

its_anandrjs — Sun, 08 Feb 2015 12:03:55 GMT

You can try Interval

LOAD

Interval(END_DATE - Begin_Date,'dd') AS Diff

From Source;

Ex:-

LOAD *,Interval(END_DATE - Begin_Date,'dd') AS Diff;

LOAD

Date(Date#(Begin_Date,'DD-MMM-YYYY'),'DD-MMM-YYYY') as Begin_Date,

date(Date#(END_DATE,'DD-MMM-YYYY'),'DD-MMM-YYYY') as END_DATE;

LOAD * Inline [

Begin_Date ,END_DATE

01-JAN-2014,31-JUL-2014

01-FEB-2014,31-JAN-2015

01-MAR-2014,25-JAN-2014

];

And you have to ensure you have proper date formats in the date fields

Regards

Anand

upaliwije — Sun, 08 Feb 2015 13:59:18 GMT

thanks