Difference between 2 dates

[nandini]

Hi,

Using VBA in MS Access, how can I find the difference between 2 dates as X years Y months and Z days.

Thanks in advance.
Nandini

[Allen Noakes]

Try using the function "DateDiff". It will return the info you want. Check MSDN documentation for more info.

Allen Noakes
VB Programmer/Analyst
Dames & Moore Group

[tarandhingra]

you can use datediff function for getting the diiference between two dates.

you hav to specify that in which format do u want the difference like u want difference in terms of days or month or year etc.

u can check help for the exact syntax in case u find ne prob u can drop me a mail at [email protected]