Date Difference

[#1]

I have a Two Column Date of Joining and Date of Resignation ...

Example :Date of Joining - 01/01/2012  And  Date of Resignation - 02/05/2015

so i want the Out Put how many Year Month and Day Employee works.. like .. 3 year 4 Month and 1 Day ...

Plz Tell me

[#2]

Header 1

Kindly check this.. i formatted a Excel File

[anbu1984 · Accepted solution]

Load *,Floor(Days/365) & ' Years ' & Floor(Mod(Days,365)/30) & ' Months ' & Mod(Mod(Days,365),30) & ' Days ';
Load *,Interval(DOR-DOJ,'DD') As Days;
lOAD *
FROM
ExcelDemo.xlsx
(ooxml, embedded labels, table is Sheet1);

[#4]

Thank U So Much.....

Its Working...

Thanks Once Again For Support and Time ....

[anbu1984]

If your queries are answered, close this post marking helpful/correct ans