I am not sure I understand what you want to do. Can't you just delete any record where the date is greater than 7 days ago?
Maybe answer this: How do you tell if you should delete a record? ....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com "Some people call me the space cowboy. Some people call me the gangster of love." -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, June 08, 2006 9:18 AM To: CF-Talk Subject: Find which records have changed over a 7 day period. Anyone care to chime in on this? I've posted a thread which hasn't gotten many responses yet and I'm wondering if any of you SQL wizards have input. http://www.sitepoint.com/forums/showthread.php?t=389438 <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54