Date range

[eacollie]

How do I query a recordset containing [StartDate] and [EndDate] for records with dates in between these?

For example, if I have a record with [StartDate] = 06/02/2011 and [EndDate] = 06/08/2011, how do I capture this in a query where I'm looking for records from 06/05/2011 to 06/11/2011?

Thanks!

[alansidman]

For example, if I have a record with [StartDate] = 06/02/2011 and [EndDate] = 06/08/2011, how do I capture this in a query where I'm looking for records from 06/05/2011 to 06/11/2011?

Are you looking for

1. all records starting between those dates?
2. all records ending between those dates?
3. only those records having a start between those dates and an end between those dates.

Depending on what you desire will dictate the criteria. Your explanation of what you want is a little vague.

Alan

[eacollie]

Thanks alansidman.

These records are for events.

For example, if I have an event with [StartDate] = 05/01/2011 and [EndDate]= 06/02/2011

and I want to look at the events for the week of 05/22/2011 to 05/28/2011, I want this event to display because it falls within this date range (5/22-5/28).

Is there a function that allows me to do that?

[alansidman]

So you want to see all events starting during that period and all events ending during that period.

In the criteria for the StartDate put =>#5/22/2011#
In the criteria for the EndDate on one line below the criteria above put =<#5/28/2011#

Alan

[eacollie]

Thanks alansidman.

In my example, the event doesn't start or end during that period of time. It starts before the selected date and ends after the selected date.

[alansidman]

It would really help me understand what you are doing if you answered my earlier thread specifically.

I am only guessing as you are not specific in what you want.

Which of these applies

Are you looking for

1. all records starting between those dates?
2. all records ending between those dates?
3. only those records having a start between those dates and an end between those dates.

[June7]

So, by your description, in addition to the options listed by alan:
4. records where the given date range is wholly within the event's range

All of these scenarios must be considered. Do you want records that meet ANY of them?

Check out this thread http://forums.devarticles.com/micros...ng-354178.html

[eacollie]

Thanks for the help. I think #1, #2, and #4 should cover all.