Yeah you can do that.
WHERE dateFormat(Now()) BETWEEN '#cal_date#' AND '#cal_date_end#'
Doug
- Original Message -
From: "Mark Leder" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, December 09, 2001 9:51 PM
Subject: SQL Query Statement
> I have two date fields (cal_date_start and cal_date_end). The dates are
> formatted as mm/dd/.
> How would I write a WHERE clause when querying the db to retrieve the
> records between the two dates (maybe using the "BETWEEN" statement)?
> It's OK to get records on the actual start date and end date. - So if
today
> is 12/09/2001, its OK to retrieve records between 12/07/2001 and
12/16/2001.
>
> In other words: WHERE DateValue(Now()) BETWEEN cal_date_start AND
> cal_date_end.
>
> Thanks,
> Mark
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists