Query data using two date columns

[Hassan_Nadeem]

Hi,

I have a table to store weekly records. In there, I have two columns “Date From” and “Date To”

I need to create a dashboard where user puts in a Date Range and it takes both the “Date From” and “Date to” column into account,

If it was just one date column then I could have easily done a query and filter but how do I take 2 date columns into account?

Attaching screenshots for better understanding.

[Hassan_Nadeem]

On the second screenshot, if I query for lets say 26th December to 29th December,

then it should return the 2nd and 3rd row as those week dates fall under the date range I selected.

[Jeff_Hager]

Just off the top of my head, but something like this might work in a Query:
EntryFrom <= DateTo
AND
EntryTo >= DateFrom

[Hassan_Nadeem]

That was so easy! Thank you