Date Records

[Paul Giesenhagen]

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]

---