Query between dates (1 Viewer)

eacollie · Jul 8, 2018

I have a [StartDate] and[EndDate] and I want to select any records that fall between these two dates. If I select [StartDate] >= date1 and [EndDate] <= date2, I don't get the records that have a start date BEFORE the date1 but occurred during this date range.

How do I write the query for this?

Thank you!

Ranman256 · Jul 8, 2018

If the dates are in text boxes on the form,

Select * from table where forms!myForm!txtDate1 >= [startDate] and forms!myForm!txtDate2 <= [endDate]

eacollie · Jul 9, 2018

Thank you. That gives me anything starting after that date. I want to select anything happening BETWEEN those dates.

For example:
[StartDate] = 1/1/2018 and [End Date] = 1/6/2018

If I select anything starting 1/2/2018 I don't get the above included in the result.

jdraw · Jul 9, 2018

see this re Overlap dates from PBaldy

Can you give us some sample data and also show us what this(anything) means exactly with your sample?

I want to select anything happening BETWEEN those dates.

Click to expand...

eacollie · Jul 9, 2018

Thank you jdraw! That's EXACTLY what I was looking for. (And thank you PBaldy).

jdraw · Jul 9, 2018

You're welcome - Paul Baldy and I are happy to help.
Good luck.

Query between dates (1 Viewer)

eacollie

Registered User.

Ranman256

Well-known member

eacollie

Registered User.

jdraw

Super Moderator

eacollie

Registered User.

jdraw

Super Moderator

Similar threads

Users who are viewing this thread