I’m running a weekly ‘contest’ and was wondering if there was anyway I could perform a ‘search for’ on a column using a static timezone(:extract week)? I’ve successfully done this using the client date/time but I really need to be able to perform the search using a static timezone (pst).
It seems I’m unable to set a static timezone AND extract anything from it (day, week, etc). When I go to use :extract after I’ve selected a static timezone it only offers the option to select email stuff. Any ideas?