Add months to date

[Bob Sanderson]

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

[Stewart Allen]

=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

[Bruce M. Thompson]

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

[Bob Quintal]

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.