Date Problem

J

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?
 
B

Bob Barrows [MVP]

Jay said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top