[rt-users] search for 'this week'?
jeffrey.pilant at bayer.com
Fri Apr 15 13:19:39 EDT 2016
Stephen Dowdy wrote:
> I created saved searches:
> "This Week's Tickets" = Created > 'Last Sunday'
> "Last Week's Tickets" = Created > 'Sunday Before Last' AND Created <
> 'Last Sunday'
> "Today's Tickets" = Created > 'Midnight'
> "Yesterday's Tickets" = Created > 'midnight 1 days ago' AND Created
> < 'midnight'
> adding from there, you should be able to modify for Resolved, Owned by Me,
Hope you don't put in tickets on Sunday or at midnight.
[Likely safe bet, but just in case...]
Query should be something like:
"This Week's Tickets" = Created > 'Last Sunday'
"Last Week's Tickets" = Created > 'Sunday Before Last'
AND Created <= 'Last Sunday'
"Today's Tickets" = Created > 'Midnight'
"Yesterday's Tickets" = Created > 'midnight 1 days ago'
AND Created <= 'midnight'
The information contained in this e-mail is for the exclusive use of the
intended recipient(s) and may be confidential, proprietary, and/or
legally privileged. Inadvertent disclosure of this message does not
constitute a waiver of any privilege. If you receive this message in
error, please do not directly or indirectly use, print, copy, forward,
or disclose any part of this message. Please also delete this e-mail
and all copies and notify the sender. Thank you.
For alternate languages please go to http://bayerdisclaimer.bayerweb.com
More information about the rt-users