Skip to Content
0
Former Member
Oct 23, 2007 at 02:58 AM

convert two dates difference to number of years, months and days

309 Views

Post Author: gigimonu

CA Forum: Formula

I wanted to write a formula (if there is a function I can use) that can convert a date difference to total number of years, months and days example

adate = 10/22/2006

?xdate = current date - adate (answer should be 1 years, 0 months and 0 days)

Please help

Thanks