I am trying to write a filter that produces the following :-
([StartDate] >= @StartDate
[EndDate] <= @EndDate )
([EndDate] >= @StartDate
([StartDate] <= @StartDate
[EndDate] >= @EndDate )
([Status] = @Status)
All attempts so far have failed, could anyone please help?
We have already answered your question in the support ticket you have open on this. I'm pasting the response for completeness.
This should look similar to the following: