I have a calendar with events: Calendar always have a start point and end point ( example 29.04.2014 till 09.6.2014)
Events are shown from this date range:
AND DATE(event_from) >= DATE(?) //29.04.2014
AND DATE(event_to) <= DATE(?) //09.6.2014
But if event starts 28.04 and ends 10.6.2014 it want shown in calendar
How can I show this event if it exceeds the range, but also remains in range
Thanks to klin:
All together
AND (daterange(DATE(event_from), DATE(event_to)) && daterange(DATE(?), DATE(?))
OR(
DATE(event_from) >= DATE(?) AND DATE(event_to) <= DATE(?)
)
)