Quiry with dates does not work

[fluiter]

Whitout the BETWEEN dates, all records will be displayed, but as soon as i
set the date periode in the SQL
NO data is displayed.

What do i do wrong.

This is code ;
<cfquery name="test" datasource="issue">
SELECT * FROM tbl_issue
WHERE date_issue BETWEEN #2004-01-01# AND #2004-05-04#
ORDER BY issue_number ASC
</cfquery>

[paross1]

Are #2004-01-01# and #2004-05-04# variable names? That is what you are saying
by enclosing them in # characters.

Something like this, maybe?

<cfquery name="test" datasource="issue">
SELECT * FROM tbl_issue
WHERE date_issue BETWEEN '2004-01-01' AND '2004-05-04'
ORDER BY issue_number ASC
</cfquery>

OR

<cfquery name="test" datasource="issue">
SELECT * FROM tbl_issue
WHERE date_issue BETWEEN #createODBCDate("2004-01-01")# AND
#createODBCdate("2004-05-04")#
ORDER BY issue_number ASC
</cfquery>

[fluiter]

Thanks for your help it's working now.