set date 6 months ahead on a day.

[Alan]

Hi
I have to set a date based on another. So I have startdate of say
January 3, 2007 and need to set an enddate approx 6 months from this
date ending on the 3rd - July 3, 2007. Any help is appreciated. Alan

 

[Yumex85]

Hi alan

Try using the Datedd function
Like this:

dateadd("m",6,"2007/1/3")
First argument is D for days, or m for month or y for year
then the number u wanna add
then the start date


I hope this helps you

Yumi

 

[Guest]

Hi Alan

On a form
=DateAdd("m", 6, [DateField])

In a query
6months:=DateAdd("m", 6, [DateField])

will give you 6 months from the date field

Not really sure how to do an approx date

You can use
6months:=DateAdd("m", 6, Date())
To give you 6 month from current date

 

[James A. Fortune]

Hi alan

Try using the Datedd function
Like this:

dateadd("m",6,"2007/1/3")
First argument is D for days, or m for month or y for year
then the number u wanna add
then the start date


I hope this helps you

Yumi

According to the help file, yyyy is Year and y is Day of year. That's a
common mistake.

James A. Fortune
(e-mail address removed)