I have used something like this in the past ( Substitute $TIMESTAMP$ or $SERVERTIMESTAMP$ for 'Create Date' ) Example of between 1 AM and 5 AM ((((('Create Date' - "1/1/70" ) % 86400) >= (1 * 3600)) AND ((('Create Date' - "1/1/70") % 86400) <= (5 * 3600))))
The Logic is as follows Take the date/time and subtract the constant of the first date allowed. This converts the date/time to an integer internally in seconds. MOD the date by the number of seconds in a day (This gives you the time of day) You can then do your comparisons Fred -------- Original Message -------- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Friday, August 12, 2016 12: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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"