Ron, To get records NOT modified in the last 2 weeks, put something like this in your search:
'Modified Time' < ( $TIMESTAMP$ - (60*60*24*14)) Or better, from the current day's date (at midnight): 'Modified Time' < ( $DATE$ - (60*60*24*14)) That's sixty (seconds) * sixty (minutes) * 24 (hours) * 14 (days). David David Durling University of Georgia > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Young, Ronald P. > Sent: Thursday, January 30, 2014 3:17 PM > To: arslist@ARSLIST.ORG > Subject: Re: Date question > > Sorry about that...I may have confused you...I am looking for records that > have been modified more than 2 weeks ago...not with in the 2 weeks. 1st > sentence was backwards... > > Thanks, > Ron Young > > "Believe you can and you’re halfway there." > ~Theodore Roosevelt > > > -----Original Message----- > From: Ron Young [mailto:rpyo...@southernco.com] > Sent: Thursday, January 30, 2014 1:56 PM > To: arslist@ARSLIST.ORG > Cc: Young, Ronald P. > Subject: Date question > > User 7.6 Dev 8.1 > > Got a question. How would I ask for a report to spit out records that have > only been modified with in the last 2 weeks. > > This is the statement below that I am using and it works but it pulls up all > files > even ones that were say modnified today or yesterday. I only need items > that haven't been updated or modified with in the 2 weeks. > > ('*Assigned Group' = "SIA_Field_MOB" OR '*Assigned Group' = "SIA_Field" > OR '*Assigned Group' = "SIA_Field_North" OR '*Assigned Group' = > "SIA_Field_SEA" OR '*Assigned Group' = "SIA_Field_SOU" OR '*Assigned > Group' = "SCADA-Subs" OR '*Assigned Group' = "SCADA-Lines") AND > ('*Status' ="Hold" OR '*Status'="Assigned") > > > __________________________________________________________ > _____________________ > 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"