Re: SQL Between dates

[Ian Skinner]

projectproofing wrote:
> That is what I thought. The toDate is a date/time. How can I cast the arguments 
> as date. I tried CAST(#arguments.startDate# AS Date) but it exploded.
>
>  Oddly TODATE >= #arguments.startDate# works, but <= #arguments.endDate doesn't.

IN CFML it would be createODBCDate() or better yet the <cfqueryparam 
...> tags I mentioned in my previous reply.