Reporting on Schedule Entry

[lucsutherland]

I'm trying to run a report on the Schedule Entry table (cmn_schedule_span), but when I try to filter it by the date, the options for the Start Date Time and End Date Time are only "is", "is not", and "is anything." How am I able to filter on normal time values (ie "last month", "after X date")?

Also, if I switch the report type to calendar, the only values that are available in the Calender by field are "Created" and "Updated". I think I should expect to see the date values for the actual windows.

(Please don't answer with a link to the SN wiki without an explanation; I couldn't find a good answer there, so I'm asking here)

[Katie Irvine1]

@Scott E @Chad Wilhelm @lucsutherland Did you manage to come up with a workaround to this issue without changing the field type from Schedule Date/Time?  How do we sort by date etc on that column in the cmn_schedule_span table?