Between Dates

[javman]

I am trying to query an online access database and return records that have
occurred between dates. I am using another query which does work to produce the
start and finish dates.
<cfif isdefined ("form.Period")>
<cfquery name="PayPeriodSelect"
datasource="#Request.MainDSN#">
SELECT *
From
OilEmployeeTime
Where
(Finish Between ##PayPeriod.Start## And ##PayPeriod.Finish##);
</cfquery>
<cfdump var="#PayPeriodSelect#">
<cfdump var="#form.period#">
</cfif>
Does anyone have any ideas where i am going wrong. Thanks

[TA-Selene]

Can you clarify exactly what the problem you are having is?

[javman]

I have sort of got the date function to work.
I was using a result from another query in by date query which did not work
since I was working with a 14 day pay period I changed the query to use a form
variable.
<cfif isdefined ("form.Start")>
<cfquery name="PayPeriodSelect"
datasource="#Request.MainDSN#">
SELECT *
From
OilEmployeeTime
Where
Area Like '#Request.Area#' And (Start > #DateFormat(form.start,
"mm/dd/yyyy")#)<!--- And (Finish < #DateFormat((form.start+14),
"mm/dd/yyyy")#)--->;
</cfquery>
<cfdump var="#PayPeriodSelect#">
<cfdump var="#form.Start#">
</cfif>

This works but it does not allow the second part of the sql. When I use that i
get a syntax error

[OldCFer]

Use #CreateODBCDate(form.start)# to pass your dates to the DB

[pwizzard]

I have been using a piece of code in a query that works fine with Access but
not with mysql. i need to show all the records that fall between NOW() and the
next three days.

Could anyone help with the code necessary to get the same to work with mySQL.

Thanks

WHERE tblMatches.betend BETWEEN NOW() AND NOW() +3

[pwizzard]

Perfect, thanks very much.