Date difference

[upaliwije]

Hi

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]

Try something like :

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

[upaliwije]

Thanks

But it is not working

[its_anandrjs · Accepted solution]

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]

thanks