By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Add months to date

P: n/a
I need to add a number of months to a date field to derive a new date
field. I can get the addition to work but it adds the number in days
instead of months. In the example below, I want to add 12 months to the
first field to obtain the derived field. Is there a function that will do
what I want?

Example:

Last Calibrated: 7/25/03
Calibration Cycle: 12 (months)
Calibration Due: 7/25/04 <-- this is the field I want to derive

Thanks in advance
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
=DateAdd("m",12,[LastCalibrated])

"Bob Sanderson" <xn***@LUVSPAMsandmansoftware.com> wrote in message
news:Xn**********************************@167.206. 3.2...
I need to add a number of months to a date field to derive a new date
field. I can get the addition to work but it adds the number in days
instead of months. In the example below, I want to add 12 months to the
first field to obtain the derived field. Is there a function that will do
what I want?

Example:

Last Calibrated: 7/25/03
Calibration Cycle: 12 (months)
Calibration Due: 7/25/04 <-- this is the field I want to derive

Thanks in advance

Nov 12 '05 #2

P: n/a
> I need to add a number of months to a date field to derive a new date
field. I can get the addition to work but it adds the number in days
instead of months. In the example below, I want to add 12 months to the
first field to obtain the derived field. Is there a function that will do
what I want?

Example:

Last Calibrated: 7/25/03
Calibration Cycle: 12 (months)
Calibration Due: 7/25/04 <-- this is the field I want to derive


Try the DateAdd() function:

DateAdd("m", 12, [DateLastCalibrated])

--
Bruce M. Thompson
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #3

P: n/a
Bob Sanderson <xn***@LUVSPAMsandmansoftware.com> wrote in
news:Xn**********************************@167.206. 3.2:
I need to add a number of months to a date field to derive a
new date field. I can get the addition to work but it adds
the number in days instead of months. In the example below, I
want to add 12 months to the first field to obtain the derived
field. Is there a function that will do what I want?

Example:

Last Calibrated: 7/25/03
Calibration Cycle: 12 (months)
Calibration Due: 7/25/04 <-- this is the field I want to
derive

Thanks in advance


DateAdd(interval, number, date)

the interval you want is "m", for month.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.