Calculating the number of months

  • Thread starter Thread starter Ben Small
  • Start date Start date
B

Ben Small

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
 
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.
 
Back
Top