I'm pretty sure it includes the start and end date, but one thing to keep in mind, if you start using datetimes, is the 24:00 (the time part) on the end datetime. Don't look like it, but keep it in a corner of the mind, JIC. Or whatever. heh.
Does cfqueryparam automagically transform "plain text" dates into real dates? 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 check 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 dd/mm/yy? Guess it defaults to one of them, right? Man, dates are so fun. Just random musing, no real help here, move along. :Denny On 7/30/06, Bobby Hartsfield <[EMAIL PROTECTED]> 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 > #createODBCDate(form.end_date)# > > 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:[EMAIL PROTECTED] > 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. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248196 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4