something like WHERE (yourdate > startdate) AND (yourdate < DateAdd(startdate, "dd", 1))
So it should get the dates from midnight (0.00) on the 12th until 11.59.59 on the 12th. check the syntax etc, but something like that... Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Justin MacCarthy" To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: .ie> Subject: RE: [ cf-dev ] date functions in QoQ or in-memory sub queries 07/07/2003 15:49 Please respond to dev problem is 12/12/2003 14.00.00 <> 12/12/2003 J -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 15:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] date functions in QoQ or in-memory sub queries I havent really used QoQ as I have never needed to but isnt it just : <cfquery dbtype="query" name="getevents"> SELECT label FROM [QUERYNAME] WHERE startdate = '12/12/2003 14.00.00' <cfquery> -----Original Message----- >From: Justin MacCarthy [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 15:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] date functions in QoQ or in-memory sub queries Can sound point me to a reference or example of using date function in QoQ (in-memory sub queries) if i have date in a query like this label startdate ------------------------------ something1 12/12/2003 5.00.00 something1 12/12/2003 14.00.00 and I want to query it for events that start on the 12/12/2003, how would I do it? What is available to me..? Thanks Justin -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
