I am trying to get total date difference between two dates in crystal formula
for example if i enter
Date1 17/03/2006
Date 2 06/01/2005
The need the result should be like 1 year 2 months ...days etc.,
I used this formula for getting the difference in years
But now i want the full difference in months and days
DateDiff ('yyyy',{Date1},{Date2})
Any ideas please
Thanks
