Calculate difference between 2 dates in months and remaining days

[Guest]

***Novice user***

Calculate difference between 2 dates in months and remaining days

I need to do the above calculation in an access database.
Can calculate the difference in months OR days but do not know how to do
calculation to return what is required.

any help greatly appreciated

 

[Duane Hookom]

Check out the function at Doug Steele's web site
http://members.rogers.com/douglas.j.steele/Diff2Dates.html.

 

[Guest]

Check out the function at Doug Steele's web site
http://members.rogers.com/douglas.j.steele/Diff2Dates.html.

--
Duane Hookom
MS Access MVP





Checked it out and although I get the idea, how do I use it

 

[Duane Hookom]

Copy and paste the code into a blank module and then save the module with a
name of "modDateCalcs". You can then use the function like you would use any
other function.