DateAdd Function Error

[bradmaunsell]

I have an error regarding the DateAdd function. I tried this with Access 97 and Access 2000 and get the same results. Am I missing something?

MsgBox DateAdd("m", 1, "31-jan-00&quot returns 2/29/00 (Correct)
MsgBox DateAdd("m", 1, "31-jan-01&quot returns 2/28/01 (Correct)

But....
MsgBox DateAdd("m", 1, "30-apr-02&quot returns 5/30/02 (Why not 5/31/02?)

also
MsgBox DateAdd("m", 1, "30-sep-02&quot returns 10/30/02 (Why not 10/31/02?)

It acts like it dosen't know the number days for every month.

Thanks,
Brad Maunsell
South Burlington, VT

 

[bradmaunsell]

Forget this one - must of experienced a senior moment!

I was expecting it to add and result in the next month-end, which of course it not what is is intented to do.

Brad