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]

Hi Brijesh,

have a look at the interval function, this should help you in creating this

Joe

[nagarjuna_kotha]

Hi,

Can u share Sample file to better understand ?

Regards,

Nagarjuna

[tyagishaila]

You can try it,

Day(EndDate)- Day(StartDate)

Month(EndDate)- Month(StartDate)

Year(EndDate)- Year(StartDate)

[sujeetsingh]

Use Interval() function of Qlik

[anbu1984]

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 Date#(DOJ,'DD/MM/YYYY') As DOJ,Date#(DOR,'DD/MM/YYYY') As DOR Inline [
DOJ,DOR
01/01/2012,02/05/2015 ];

[#7]

Thanks Anbu

can u as well help me in your code if i have DOJ column and DOR column...

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 Date#(DOJ,'DD/MM/YYYY') As DOJ,Date#(DOR,'DD/MM/YYYY') As DOR Inline [
DOJ,DOR
01/01/2012,02/05/2015 ];

so instead of writing date 01/01/2012,02/05/2015 ]; what i need to write..

so sry ,,i m new in qlikview so i m getting doubt..

[#8]

But how to write code.. i have a data like

Date of Joining      Date of Resignation                  Total Number of Period Person worked

01/02/2012              05/06/2014

04/12/2011               06/01/2015

i want to Out put to show like total Period worked i.e 3 Year 6 Month 4 day...

[#9]

But how to write code.. i have a data like

Date of Joining      Date of Resignation                  Total Number of Period Person worked

01/02/2012              05/06/2014

04/12/2011               06/01/2015

i want to Out put to show like total Period worked i.e 3 Year 6 Month 4 day...

[anbu1984]

What is your input? Excel or Database?