You could also create an integer field called Hour and, in the first If Action of your Filter, set the field to HOUR($TIMESTAMP$) - then do comparisons. The set fields action will set a value between 0 and 23 based on the 24-hour clock.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Friday, August 12, 2016 3:25 PM To: [email protected] Subject: Re: Limit Time Of Day a Filter Runs 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:[email protected]] On Behalf Of Arner, Todd Sent: Friday, August 12, 2016 12:51 PM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"
