I have a calendar view that I want to display all items where:
Start Time = Greater than or equal to [Today]
-and-
End Time = NOT Greater than [Today]
Basically, I want to view all items scheduled for Today, when the items span multiple days.
Is there any way to do this with out of the box SP?
You can use
Start Time = Greater than or equal to [Today] and
End Time = Less than or equal to [Today]
If you want a view to show all events scheduled for Today, when the items span multiple days, then I suggest you use an algorithm to detect overlapping events with today inside your view.
So you would add a view with three filter columns in the AND:
End Time is greater than or equal to [Today] AND
Start Time is less than or equal to [Today] AND
Recurrence is equal to No
If you dont add the last bit, then you will get recurring events (like birthdays or holidays) showing up in your view, which I don't think you want.
