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
Printable View
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
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
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]