Todd I use this one to limit the filter between Saturday, 9AM to Sunday, 9PM.
((($TIMESTAMP$ > ($DATE$ + ((60 * 60) * 9))) AND ($WEEKDAY$ = "Saturday")) OR (($TIMESTAMP$ < ($DATE$ + ((60 * 60) * 21))) AND ($WEEKDAY$ = "Sunday"))) Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Friday, August 12, 2016 1:51 PM To: arslist@ARSLIST.ORG 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 no...@glhec.org<mailto:no...@glhec.org> 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"
