Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Reporting on Schedule Entry

Go to solution
lucsutherland
Mega Contributor

‎08-11-2017 02:46 PM

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)

Labels:
  • 1,935 Views
1 ACCEPTED SOLUTION

Go to solution
sachin_namjoshi
Mega Patron

‎08-11-2017 02:59 PM

This is happening since data type for start   and end dates is Schedule Date/Time.


You will get date filters ( last week, last month ) ... in date time fields.



Regards,


Sachin


View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
Katie Irvine1
Kilo Contributor
In response to Scott E

‎08-11-2021 03:22 AM

@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?

0 Helpfuls