RS error : Syntax error converting datetime from character string

[specialist]

Greetings-

Happy holidays to all who read this. I am having a problem with trying to query a table
to get all entries between a start date and end date (query is below)

I am using macromedia dreamweaver mx and upon entering the info into the recordset window and testing the query
I get the following error: "Syntax error converting datetime from character string".

In the SQL db, the data type for "tblInfo" is daetime, so I am not certain what the issue is. Any advice would be wonderful

Thank you in advance!

Mike

SELECT COUNT (Entries) AS Entries_ALA
FROM tblInfo
WHERE Sort = ('S') AND Category = ('3')
AND place = ('Ala')
AND MTR BETWEEN '" & StartDate & "' AND '" & EndDate & "'
AND Complete = ('1')
OR Sort = ('S') AND Category = ('4')
AND place = ('Ala')
AND MTR BETWEEN '" & StartDate & "' AND '" & EndDate & "'
AND Complete = ('1')

 

[HowardMarks]

Have you tried surrounding the dates with hash symbols instead of quotes e.g.

AND MTR BETWEEN #" & StartDate & "# AND #" & EndDate & "#"

I think that may be your problem.


Nick (Webmaster)

info@npfx.com

http://www.npfx.com

http://www.artswales.org

 

[specialist]

That did not work, I believe that # is for Access only correct?