Hi there
I am running into big problem about using dateadd function to control a query(My
monthly report base on this query). My function is >=Date()-DatePart("d",Date())+1
And <=DateAdd("m",1,Date()-DatePart("d",Date())). However, it worked fine
with everymonth of year 1997, 1998, 1999, but execept this year because
it can not recognize the month of March 2000 where has 31 days, April has
30 days, and May has 31days
I wonder if anyone has same problem and know how to solve it. Please show
me if you have any Ideas how to solve it. Thanks in advance