then...
WHERE lastDateEdited >= #CreateODBCDate(dateminus30)#
AND lastDateEdited <= #CreateODBCDate(now())#
Andrew.
----- Original Message -----
From: Paul Giesenhagen <[EMAIL PROTECTED]>
Date: Mon, 6 Sep 2004 03:32:33 -0500
Subject: Date Records
To: CF-Talk <[EMAIL PROTECTED]>
I need to pull records out that have a date stamp of less than or
equal to the past 30 days. My WHERE statement would be what?
WHERE lastDateEdited = past 30 days (if LONGER than 30 days, I do
not want to include this record into the resultset).
Oh CFMX 6.1 and SQL 2000
Thanks in advance.
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
