I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use , ? And the key
for equal to or less?
Chuck Payne
Magi Design
On Wednesday, 20. March 2002 18:31, Chuck PUP Payne wrote:
Hi!
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use , ? And the key
for equal to or less?
select * from accounts where duedate=convert(float,getdate())
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 12:31 PM
Subject: Date and SQL statement
I need to do a search where I am looking at the table that has