I seem to remember some issues using $DATE$ and $TIME$ in qualifications. How about something like:
( ((( $TIMESTAMP$ - "1/1/70") % 86400) >= (7 * 3600)) AND ((( $TIMESTAMP$ - "1/1/70" ) % 86400) < (19 * 3600)) ) Description of above qualification: (This gives you >= 7:00 AM and < 7:00 PM) Subtract off the start of time (for TimeStamps) to convert TIMESTAMP to an integer (if you don't do this ARS tries to work with TIMESTAMP as a string). Use the Modulus "%" (remainder after division) of number of seconds in a day (86400) to get the number of seconds since Midnight. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Friday, December 07, 2007 4:42 AM To: [email protected] Subject: Re: Execute filter between specific time of the day Hi, I guess that you would want your filter to run at each transaction but only during the designated times. This could work in theory: $TIMESTAMP$ - $DATE$ >= 25200 AND $TIMESTAMP$ - $DATE$ < 68400 Otherwise I would suggest that you do this in two filters. First filter sets an integer field to ($TIMESTAMP$ - $DATE$). The second one checks ('tmpSecondsToday' >= 25200 AND 'tmpSecondsToday' < 68400) Best Regards - Misi, RRR AB, http://www.rrr.se > If it were me, I would create an escalation, or an escalation that > fires the filter. > > ----- Original Message ----- > From: Action Request System discussion list(ARSList) > <[email protected]> > To: [email protected] <[email protected]> > Sent: Thu Dec 06 07:13:04 2007 > Subject: Execute filter between specific time of the day > > ** > > Hi, > > > > Can someone help me create a filter to execute from 7.00.00 AM to > 7.00.00 PM. > > I have tried the following Qualification but it still fires of after > 7.00.00 PM. > > > > I have tried many options > > > > Option 1 running on one filter – fires after 7.00.00 PM as well > > $TIME$ > 25200 OR $TIME$ < 68400 > > > > Option 2 broke it up into 2 filters > > Filter 1 > > $TIME$ > 25200 > > Filter 2 – Does not fire off ever > > $TIME$ < 68400 > > > > Option 3 > > Set the Start time (7.00.00 AM) in a temp Time Field and the End time > in another Time Field > > ‘Start time’ < $TIME$ AND ‘End Time’ > $TIME$ > > This qualification gives me a data relational error. > > > > Regards, > Darshana Jivan > Application Developer > > ): Cell: 0832000451 > *: Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > MTN Corporate > 39 Rivonia Road > No1 Commerce Square 3rd Floor > Sandhurst > Johannesburg > 2196 > P.O. Box 3070; Randburg; 2125; South Africa. > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
