I haven't been able to find documentation on how to use the "during following" operator options in the Advanced Search feature.

Go to Support Desk, Tickets, click "Advanced Search", pick the "Created Date" field, then the next field to the right has options at the bottom of the list "during following weeks", "during following months", etc.  Once selected, the next field to the right is a blank text box.  What should I put in that box?  A date? A month name?

Answer Summary:
0 Comments   [ + ] Show Comments


Please log in to comment

Answer Chosen by the Author

Looking at your question, there may be some confusion here. When you select a date based field to search, query or add to a report, you have made a available a number of "Extended Date Operators" which basically allow you to program some quite complex SQL by using a single statement such as "During Previous" or "During Following".

Logically you need to think about what you are asking the query to do.

To answer the question straight you need to put a number for example 3, so in plain English, your statement will be saying:

"Show me all the calls with a created date that is within the next 3 Months" 

For the purpose of a query or report, as you never log tickets with a future created date, the query will probably return no results.

However the extended date operators come into their own if you need to create weekly or monthly reports as you can use the "Within Last..." operators to create period based reports
Answered 07/06/2015 by: Hobbsy
Red Belt

Please log in to comment


Answer this question or Comment on this question for clarity