Date falls between StartDate and EndDate?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi there,

How can I return records where a date falls between the StartDate and
EndDate of a table.

Group : StartDate : EndDate
A : 01/01/01 : 31/01/01
B : 10/01/01 : 20/01/01
C : 20/01/01 : 25/01/01

i.e: A date of 18/01/01 would return Group A and B, but not C as 18/01/01
does not fall between the StartDate and EndDate of that record.

Thanks
 
How can I return records where a date falls between the StartDate and
EndDate of a table.

Group : StartDate : EndDate
A : 01/01/01 : 31/01/01
B : 10/01/01 : 20/01/01
C : 20/01/01 : 25/01/01

i.e: A date of 18/01/01 would return Group A and B, but not C as 18/01/01
does not fall between the StartDate and EndDate of that record.
Click to expand...

Enter the following criteria for your fields:

StartDate: <=[Enter Date as 'M/D/YYYY']
EndDate: >=[Enter Date as 'M/D/YYYY']

The reference to "[Enter Date as 'M/D/YYYY']" can be just as entered, or it can
be a reference to a textbox on a form or any other reference that can represent
a date. It must, however, appear exactly the same everywhere that criteria is to
be inserted if used as above or you will be prompted multiple times.
 
Thank you.

I managed to get to the answer also, using a query on a query, but your way
is better.

Bruce M. Thompson said:
How can I return records where a date falls between the StartDate and
EndDate of a table.

Group : StartDate : EndDate
A : 01/01/01 : 31/01/01
B : 10/01/01 : 20/01/01
C : 20/01/01 : 25/01/01

i.e: A date of 18/01/01 would return Group A and B, but not C as 18/01/01
does not fall between the StartDate and EndDate of that record.
Click to expand...

Enter the following criteria for your fields:

StartDate: <=[Enter Date as 'M/D/YYYY']
EndDate: >=[Enter Date as 'M/D/YYYY']

The reference to "[Enter Date as 'M/D/YYYY']" can be just as entered, or it can
be a reference to a textbox on a form or any other reference that can represent
a date. It must, however, appear exactly the same everywhere that criteria is to
be inserted if used as above or you will be prompted multiple times.
Click to expand...
 
Back
Top