I've seen a few out there, but what is the best workaround for getting around the Content Query Web Part preventing filters on the Start Time or End Time columns of a particular Event list?
- Calculated Columns - downside is that these will now show in the Display Form unless I customize the display form. Also there seems to be some issue with calculated date/time columns based on Event Date for all day events being returned off by x hours (where x is the offset from UTC).
- Create filters using another date field (such as Created) and then export the .webpart file. Change Created date references to EventDate. Import the .webpart file to the page. I tried this and it didn't work.
- Specify a "QueryOverride" value for the web part and import it.