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.
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.
Just off the top of my head, but something like this might work in a Query:
EntryFrom <= DateTo
AND
EntryTo >= DateFrom
That was so easy! Thank you 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
