Received: from mail.rdc2.bc.home.com (ha1.rdc2.bc.wave.home.com [24.2.10.68]) by hub.org (8.10.1/8.10.1) with ESMTP id e6B6a5W69251 for ; Tue, 11 Jul 2000 02:36:05 -0400 (EDT) Received: from cr699264a ([24.113.17.57]) by mail2.rdc2.bc.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20000711052426.OXNY9731.mail2.rdc2.bc.home.com@cr699264a> for ; Mon, 10 Jul 2000 22:24:26 -0700 From: "Rob S." To: Subject: Creating timestamps in queries? Date: Mon, 10 Jul 2000 22:26:38 -0700 Message-ID: <001c01bfeaf8$96812be0$39117118@rct1.bc.wave.home.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal X-Archive-Number: 200007/115 Hi all, I would like to say, "select * from blah where stamp >= 7 days ago" ...where the "days ago" is calculated at query time; meaning that its not hardcoded into the query as a date string. Is this possible? TIA! =) - Rob Slifka