Todd, I see several folks have replied, but there are several questions that need to be answered first...
When you say "current time is".... According to WHO? And in what Timezone? Is it the server timezone you are talking about or the end user's timezone. For example, if the server is in New York and the user is in Hawaii (5 hour time difference) and the ticket is submitted at 4:32 PM Hawaii time by the user in Hawaii, do you want the filter to fire? (remember, it is now 9:32 PM in New York where the server sits) Is the filter tied to the submitter time? The server time? The assignee time? Something else? Once you address this question, you can then determine how to approach the problem as you have to be aware that time is not a fixed value, it is relative. THEN, you may be able to take advantage of the $TIME$ keyword if it is relative to the server in some way to have a nice simple qualifier. If something that depends on the submitter or the assignee, then there are lookups and calculations to do and then the qualifier can be on the result. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Friday, August 12, 2016 10:51 AM To: [email protected] Subject: Limit Time Of Day a Filter Runs ** We have a filter that is set up to send an email and need to limit it so that it only sends the email if the current time is between 7 AM and 6 PM. Does anyone know if there is a way to limit this maybe by adding a qualification to the run if statement? Any other ideas on how we may be able to limit the time of day the filter fires? We are on ARS 8.1, and SQL 2008 Thanks in advance for any help Todd Arner Great Lakes ________________________________ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to [email protected]<mailto:[email protected]> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
