I'm pretty sure it includes the start and end date, but one thing to keep in
if you start using datetimes, is the 24:00 (the time part) on the end
Don't look like it, but keep it in a corner of the mind, JIC. Or whatever.
Does cfqueryparam automagically transform "plain text" dates into real
Somehow I think it does, negating the use of createODBCdate, and, if
it's an invalid date, createODBCdate will throw an error, so be sure to
that it's valid first. Guess you'd get an error either way.
One thing that I always wonder... how does CF know if it's mm/dd/yy, or
Guess it defaults to one of them, right? Man, dates are so fun.
Just random musing, no real help here, move along.
On 7/30/06, Bobby Hartsfield <bobby@acod...> wrote:
> Try #createODBCDate(form.start_date)#
> And #createODBCDate(form.end_date)#
> ....no quotes
> There are also other ways... like...
> Where Client_Birthday BETWEEN #createODBCDate(form.start_date)# AND
> I cant remember if that actually includes the start and end date as being
> BETWEEN them.. but if not, just use dateadd 1 and -1 on them
> Bobby Hartsfield
> http://acoderslife.com >
> -----Original Message-----
> From: Michael E. Carluen [mailto:cf_mecarluen@comc...]
> Sent: Sunday, July 30, 2006 8:12 PM
> To: CF-Talk
> Subject: RE: Anyone see anything wrong with this code?
> > where Client_Birthdate >= '#Form.Start_Date#'
> > and Client_Birthdate <= '#Form.End_Date#'
> Rick, Try using <cfqueryparam> on the dates.
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four times a year.