of these:
where return_date > dateAdd(d, -14, now())
where return_date > date_add(now(), interval -14 day)
You'll also probably want to use midnight, not now(), so you do'nt cut the
day in half.
barneyb
-----Original Message-----
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 5:13 PM
To: CF-Talk
Subject: Display Records By a Certain Date
Trying to display all records from a database where the RETURN_DATE is
never more than two weeks ago..
Select * from enrollments
Where RETURN_DATE < (#Now() - 15)
Except that ain't it....
I've been awake way too long. Pointers in the right direction please?
--
Les Mizzell
-------------------------
�Mihi placent, O Pincerna!
Virent ova! Viret perna!
Dapem posthac non arcebo.
Gratum tibi me praebebo.�
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
