Think of it a different way round - you want to view records where start date is in the past, and end date is in the future.
There is no direct condition for "In the past" and "in the future" but you can fake it:
Start Date is in the Last X Years where X = 99
End Date is in the Next X Years where X = 99
This should so the trick...
Note that Last (or Next) X <time period> is "from this
moment back (or forward) X amount of periods eg years, months to the same time of day on the past (future) date". If your start or end date is displayed as a
date only and is today, then this means midnight this morning so it will be in the past. So you will see things that start today, but not ones that end today (because the end date is in the past by some number
of hours). If that is a problem, you might need to use a second end date field that is maintained as "end date + 1 day" (by workflow or plugin). use this enddate+1 field for your filter, but don't make it visible to the user on the form or in the view.
Hope this helps.
Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
UK CRM Guru Blog
