Future Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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.
 
=DateAdd("m",6,[StartDate])

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