Date woes

Assuming startdate is a date datatype, try this:

date1 = createdate(something);
date2 = createdate(something);

select *
from crabcalendar
where startdate >= #date1#
and startdate < #date2#

Once you know it's working, put those variables into cfqueryparam tags.

PaulH **AdobeCommunityExpert** wrote:
> rockhiker wrote:
>> I have used between and >= and <= but no records are returned. The
>> dates are stored in an msacess table as long dates. I tried with
>> single quote both on and off the dates - the code follows - thanks
>
> turn those strings into dates that access can handle either via
> createdate() or createODBCdate() functions.
>

Or, best yet, <cfqueryparam...> tags with cfsqltype="cf_sql_date"
parameters.

rockhiker wrote:
> I have used between and >= and <= but no records are returned. The dates are
> stored in an msacess table as long dates. I tried with single quote both on and
> off the dates - the code follows - thanks

turn those strings into dates that access can handle either via createdate() or
createODBCdate() functions.