Event Search with start date not finding current events
-
When you enter just a start date in the advanced search, events with a start date earlier than the date entered but with an end date later than the date entered are not found.
Looks like it’s this bit in events class that might be the problem:
AND event_start_date >= CAST('[date_entered]' AS DATE)
I suggest that something like this might be better:
AND ( # For all matching and future events event_start_date >= CAST('[date_entered]' AS DATE) OR # For all straddling events ( (event_start_date <= CAST('[date_entered]' AS DATE) AND (event_end_date >= CAST('[date_entered]' AS DATE) ) )
…To find events that straddle the single date. Apol.s if this formats badly!
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Event Search with start date not finding current events’ is closed to new replies.