compare date against a database

[redhat]

I'm stuck trying to compare date values from users selection against a database which is Access.
This is my problem I get two date from client with mm/dd/yyyy format transfer via form to my asp file(asp with javascript). I need to check all orders between these two date.
I know The problem is that I am comparing a date in a string against a datetime datatype, but I don't know how to change format and
which one is better string to datetime or vice versa.
Any suggestions are greatly appreciated. Thank you in advance.

[iam_clint]

string to datetime

cast(your string) as datetime

[jhardman]

query = "SELECT * FROM myDBTable WHERE dateOrdered BETWEEN #" & date1 & "# AND #" & date2 "#"

the access driver should recognize this correctly.

Jared

[redhat]

query = "SELECT * FROM myDBTable WHERE dateOrdered BETWEEN #" & date1 & "# AND #" & date2 "#"

the access driver should recognize this correctly.

Jared

I've done what you said and it's works.I'm so relieved now.Thanks a million!