# Calculating the number of months

• August 8th, 12:07 AM
Ben
Calculating the number of months
I need to calculate the Number of months that has passed
from a certain date. I have a text box that called "Hold
date" that stores the starting date and I have a text box
called "Hold Time" that stores the total amount of hold
time available. I need have the number of months that has
passed calculated and then subtract it from the total hold
time that is available. I appreciate any help
• August 8th, 12:45 AM
Van
Re: Calculating the number of months
Check Access VB Help on the DateDiff() function.

--
HTH
Van T. Dinh
MVP (Access)

"Ben Small" <com> wrote in message
news:03d901c35d41\$040db350\$gbl...

• August 8th, 12:54 AM
Ken
Re: Calculating the number of months
And watch that the month difference (as is the year difference) is based on
the month portion of the date, not on the actual days difference. Example,
DateDiff returns a value of 1 if you test the month difference between 23
April 2003 and 1 May 2003.

--
Ken Snell
<MS ACCESS MVP>

"Van T. Dinh" <bigpond.com> wrote in message
news:phx.gbl...
>
>[/ref]