Between and DateAdd Problem

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Hello, I've designed a database and I need help creating a query for it. In
the database, there are dates in the future when contracts expire. I need to
be able to create a query that allows me to pull the records that are either
30,60, 90, or 120 days away. For example, I want to be able to see the
records that are 0-30 days away, 31-60 days, 61-90, and 91-120. Is this
possible? Thanks
 
A bit more info would be useful.
Is this for a report or a form, or what?
Do you want to return one recorset with just a specific date range, or do
you want to return something that shows which data range the record is in?
From where are you running the query?
What version of Access?
 
Good observation.
I, without thinking too deeply, assumed Date()
But then I am sure you know about Assume <g>
 
Thanks for all the suggestions but I got it working. I just used this formula
and changed the days as I needed

Between DateAdd("d",+31,Date()) And DateAdd("d",+60,Date())

That would give me dates from 31-60. And I just worked around this. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top