Should Option 1 be $TIME$ > 25200 AND $TIME$ < 68400 ________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darshana Jivan [MTN Network Solutions] Sent: 06 December 2007 13:13 To: arslist@ARSLIST.ORG 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. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"