Needs help with query

[whatsaname]

I urgently require some help with the following.
I have a input page for two DATES, one date_start and one date_end.
These to variables i want to have them woring in my query. but the data will
not be loaded into an EXCEL, it stays blank.
when i use #createODBCDate("2004-01-01")# AND #createODBCdate("2004-05-04")#
then it will load the data.
But i do want to have our customers entering the start and end date for this
report download.

What do i do wrong ???


<cfquery name="laden" datasource="issue">
SELECT * FROM tbl_issue
WHERE tbl_issue.region = 'EMEA' AND tbl_issue.date_issue BETWEEN
#Form.date_start# AND #Form.date_end#
</cfquery>

[prems28]

Hi,

try and enclose the dates within single qoutes. It should work.

Prem

[whatsaname]

Yes putting the dates into the code is working, but i want to get date input
from the user working
The dates i'm getting is #Form.date_start# and Form.date_end#
How do i get those two variable input working in the query, as only the data
between these two dates are required.

[philh]

Have you tried

'#CreateODBCDate(form.date_start)#' and '#CreateODBCDate(form.date_end)#'