Calculating the number of months

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
 
K

Ken Snell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Space at end of multi page list to accommodate new entries 1
Word OLE to check spelling in text box 1
OLE Word spelling 0
Email notifications without opening application 1
Split form 0
VBA word change keys 0
Calculating a text box 10

Top