Add a day and a month with DateAdd

[Michelle]

Hello, I'm trying to use the DateAdd function to add one day and one month to
date field in my work's database. I know someone showed me how to do it
before, but I can't remember how. Can someone help?

 

[Software-Matters]

try something like this:
DateField = DateAdd("d", 1,(DateAdd ("m", 1, DateField))
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 06:48:01 -0700, Michelle

You cannot do that in one statement. Call DateAdd once to add a day,
and again to add a month to the previous result.

-Tom.
Microsoft Access MVP

 

[Klatuu]

You are missing a closing paren. Should be:

DateField = DateAdd("d", 1,(DateAdd ("m", 1, DateField)))

 

[Michelle]

Thanks!

On Thu, 23 Jul 2009 06:48:01 -0700, Michelle

You cannot do that in one statement. Call DateAdd once to add a day,
and again to add a month to the previous result.

-Tom.
Microsoft Access MVP