functions will break when you switch. This will be something like:
SELECT *
FROM enrollments
WHERE verify = 1 AND return_date > #DateAdd(d, -14, getdate())#
ORDER BY enroll_num ASC
Now() is a particular annoyance since it's also a CF function.
-----Original Message-----
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 2 October 2003 1:30 p.m.
To: CF-Talk
Subject: Re: Display Records By a Certain Date - Here's What Worked
OK, here's what worked
SELECT *
FROM enrollments
WHERE verify = 'Yes' AND return_date > #DateAdd("d", -14, now())#
ORDER BY enroll_num ASC
Thanks to those that replied!!!
This is using Access by the way. Switching to SQL Server in a few weeks...
--
Les Mizzell
-------------------------
"Mihi placent, O Pincerna!
Virent ova! Viret perna!
Dapem posthac non arcebo.
Gratum tibi me praebebo."
_____
[Todays
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
