Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try something like :
=date#('31-JUL-2014','DD-MMM-YYY') - date#('01-JAN-2014','DD-MMM-YYY')
Thanks
But it is not working
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
thanks