help!!!!!! with query

[hinser13]

I am trying to run a query that displays dates that are 30 days either side of todays date. However it's not working!

We set return dates for clients 6 months 1 year two years etc. The query runs every day at start up and should display activated return dates and continue to display for 30 days either side of the today date.

I am using this query >=Now() And <=Now()+32

but it does not seam to work, please somebody help!.

Mark

 

[pbaldy]

What does "does not seem to work" mean exactly? Given your description, I'd expect the first parameter to subtract 30 days from Now(). Personally I'd use Date() rather than now to exclude the time portion.

 

[hinser13]

I mean no dates appear although I know there are return dates. I have a return date reminder for the 08 September 2010. Using the criteria previously stated, the date does not show up?

 

[hinser13]

The query returns blank!

 

[pbaldy]

What is the SQL of the query, and does the field the criteria is on have a date/time data type?

 

[hinser13]

what i need is a query that will return me all dates 30 days either side of a criteria date

 

[pbaldy]

I understand what you want. What is the SQL of the query that fails? I expect something like this to work:

SELECT...WHERE DateFieldName >= Date() - 30 AND DateFieldName <= Date() + 30

 

[spn200286]

i posted in ya diff thread, heres what i said
Someone pointed me to this in a diff thread and it helped me alot

http://www.datapigtechnologies.com/AccessMain.htm

It has a tutorial about loads of things including different date functions

 

[hinser13]

Thank you very much for all your replies, The query DateFieldName >= Date() - 30 AND DateFieldName <= Date() + 30 worked perfect, Thanks pbaldy.

 

[pbaldy]

Happy to help.