Hi

i am trying to run a date query i have tried both the following <DateAdd("m",-1,Date())

and

<Date()+31

this keeps returning all dates past a month ago, as we in december, its bringing back all my records nov, oct and sept e.c.t.

i only want to display one month of records after e.g todays date... one month over due records for book returnshttp://www.vbforums.com/images/smilies/frown.gif

can anyone please help?

thanks

jofoxy

I don't know what you mean by, "I only want to display one month of records after e.g todays date."

Today is December 10, 2009. Which dates do you want to see? Give me a date or date range with real dates. That will help with the query parameter.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Are you looking for your query to return ALL records that are 30 days overdue from the date they were due for return?
If so...
What type of fields are you currently using for your query?:
Date Book Checked Out
Date Book Is Due For Return
Thanks!