Date Problem

[Jay]

I am trying to compare a date in my database to the current date. My SQL
statement is:

sqltemp5="select * from users where dateclosed <= '" & date & "'"

What I am trying to accomplish is exclude records where the dateclosed field
is older than todays date. Such as if dateclosed = 6/30/2004 then today
being 08/25/2004 that record should be excluded.

Any help?

[Bob Barrows [MVP]]

Jay wrote:

I am trying to compare a date in my database to the current date. My
SQL statement is:

sqltemp5="select * from users where dateclosed <= '" & date & "'"

What I am trying to accomplish is exclude records where the
dateclosed field is older than todays date. Such as if dateclosed =
6/30/2004 then today being 08/25/2004 that record should be excluded.

Any help?

Never ask for help with a query without telling us the type and version of
database you are using

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.