Date Comparison

Date Comparison

am 02.01.2005 15:56:29 von dino

I am creating a website that is going to ask the user to enter a date! then
from an access database get all records where a date field is greater then
the date entered! Sounds simple, I do it in vb all the time!

here is my sql line: Select * From Participants WHERE DateJoined > 01/14/07
ORDER BY TournamentID

it updates fine with the date the user has entered! I know in vb I need to
put ## around the date I am comparing! I tried that, I tried %%. still I
am getting all records from the database!

any and all help is appreciated!
thank you in advance.

mike