QofQ can do date comparisons. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire
Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 01, 2002 11:34 AM > To: CF-Talk > Subject: Re: QofQ and dates... > > > I don't _think_ QofQ does date comparisons ... However... You > could probably > transform the dates in the original quer(y|ies) into a > separate column i.e. > > convert(int,convert(varchar,Year(datecolumn)) + > convert(varchar,month(datecolumn)) + > convert(varchar,day(datecolumn))) AS > date > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
