I have a project where we collect a date/time field for events. I am wanting to pull a subset of the project based on the day of the week between certain times of the day without having to change the query string each time.
The following will show me everything that happens between Tuesday 12:00 AM PST and Thursday 11:59 PM PST.
project = "XYZ" AND "Start Time (PST)" >= startOfWeek(2d) AND "Start Time (PST)" <= startOfWeek(5d) AND status != Canceled ORDER BY "Start Time (PST)"
I want to get granular and show only things that happen between Tuesday 11:00 AM PST and Thursday 10:59 AM PST
