Have been tasked with creating a new report on a group's availability, however they want our weekly maintenance window excluded (Sunday 6am-10am). I have not been able to create this with the built-in query builder, I'd like to not have to write the SQL (or SWQL) query if I don't have to. Anyone have any luck?
It's entirely possible I'm missing something simple, hoping Thwack might be my 2nd set of eyes.
I have tried several iterations, all get "Query is not valid" but they all work when I don't specify a time of day (either before or after).
or (both get Query is not valid)
