DateDiff

[wizkid]

Thank you very much for your reply.
I am using CR9.
I can get the days and months with different formula
usiing 'yyyy' and 'm' in interval type.
But what i am asking is i want the entire difference in one formula

For example if i give two dates

Date1: 17/03/2006
I need the result should be like 1 year 2 months ...days etc., in one formula

for example if you give

datediff('yyyy',date1,date2) --->the result will be only in years

datediff('m',date1,date2)---> the result will be only in months

etc...


The need the result should be like 1 year 2 months ...days etc., in one formula


Any idea?