Your qualification is asking for any record where the Last E-mail Sent Date I >= 14 days ago...I think you meant <=
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shrestha, Manjari R. Sent: Tuesday, September 11, 2007 7:48 AM To: [email protected] Subject: Filter to check the last E-mail sent is not working Hello List, I am trying to create a filter that checks the last e-mail sent date and it the date more than 14 days or if e-mail has been never sent before that the filter should fire. I am using the Run if below but it fires even if the Last E-mail Sent is less than 14 days. Please advise. (( 'DB.Last E-mail Sent Date' = $NULL$ ) OR ( 'DB.Last E-mail Sent Date ' >= ($TIMESTAMP$ - 1209600))) Thank you, Manjari ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
