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"
