Use the undocumented function DATEDIF
See Chips site for details www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"srinivasa rao" <srinivasa wrote in message
...
i would like to know to how to calculate year,month and date between to
dates
Example
01/10/1977 and 10/04/2002 . i want to know the formula for getting correct
years, months and days between above dates