Quote Originally Posted by wizkid
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
i am not sure on this but i believe days would be:
VB Code:
  1. DateDiff (d,{Date1},{Date2})
and months would be
VB Code:
  1. DateDiff (m,{Date1},{Date2})