Find if a date is within range of dates.

[EDN Admin]

Scenario : I have a table that has two DATE fields. On the query form, user inputs StartDate & EndDAte.

Now I need to see which record has the start-date & end-date.
I was thinking of something like RANGE but not able to figure out.
What is the best way to achieve the above?
thanks.

View the full article