please help me calculating the days,Months and years different between 2 dates.

[#1]

I have 2 fileds,start date and end date.

How can I calculates the numbers of days,months and years difference between 2 dates.

Thanks in advanvce.

[Anonymous · Accepted solution]

If you're OK with approximate definition of Year = 365 days, and Month = 30 days, this will work:

= div(interval(End - Start, 'D'),365) & ' Years '

& div(mod(interval(End - Start, 'D'),365),30) & ' Months '

& mod(mod(interval(End - Start, 'D'),365),30) & ' Days '

Edit: see also this thread.  The question is a little different, but maybe helpful in your case:

http://community.qlik.com/message/193057