Future Dates

[Guest]

I am trying to create a field that will automatically calculate the date 6
months in advance of another date. I have used two methods and neither seem
to be working forme.

=DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))

=DateAdd([m],6,[StartDate])

Both give me the error message Invalid Syntax and the Field on my form
shows: #NAME?

Can anyone help me with this?

My start date is referring to an enrollment date.

 

[Coby]

I am trying to create a field that will automatically calculate the date 6
months in advance of another date. I have used two methods and neither seem
to be working forme.

=DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))

=DateAdd([m],6,[StartDate])

Both give me the error message Invalid Syntax and the Field on my form
shows: #NAME?

Can anyone help me with this?

My start date is referring to an enrollment date.

DateAdd("m",6, [StartDate])
Don't use bracket around the m, but use double quotes instead (ie, use
"m" Not [m])

If that does not work, then you may have to format the dates also:

For example DateAdd("m",6, Format$([StartDate], "yyyy/mm/dd")

This is done for the purpose of letting the DateAdd formula understand
which value is great than the other in time.

Coby.

 

[Steve]

=DateAdd("m",6,[StartDate])

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)