I have event startdate, enddate, and duration. I need to grab all of "Today's Events." Obviously getting events that start or end on today are easy enough, but I'm having trouble grabbing events that start before today and end after today. (If an event spans many days and today is in the middle.)
Any tips on a query would be great.
Any tips on a query would be great.