set date 6 months ahead on a day.

  • Thread starter Thread starter Alan
  • Start date Start date
A

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

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)
 
Back
Top