Oh cool, thanks for the rejoinder. :) > 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 >> > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
