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, > etc...
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' /jeff ________________________________________________________________________ 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 ________________________________________________________________________ --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016