DateAdd issue 1

[dheim70]

I've used this function before with success but today I created a query and it is returning the wrong date. I have the following as a calculated field in my query: Due DateX: DateAdd("m",9,"06/30/2011")

And is returning the following 03/30/2012 instead of the correct value 03/31/2012

Has anyone seen this before? I am using access 2007

Any help would be greatly appreciated!

Thanks D

 

[Andrzejek]

Why would you say correct value is 03/31/2012? And not what you are getting: 03/30/2012

If you add 9 months to 03/[blue]30[/blue]/2011, you get 03/[blue]30[/blue]/2012


Have fun.

---- Andy

 

[SkipVought]

Ditto.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

It you want the last of the month, 9 months out, rather than just 9 months...

DateSerial(Year("06/30/2011"), Month("06/30/2011") + 10, 0)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dheim70]

Yup, should have worded that better.

Thanks for the code Skip, that is what I needed.

much appreciated!