Haven't tested it, but try putting the earliest date first: BETWEEN GETDATE() AND DATEADD(hh,24,GETDATE())
HTH D ************************ Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:04 PM To: SQL Subject: BETWEEN and date functions Hi all, I have the following query, trying to pull out login attempts that have occurred within the past 24 hours: SELECT attempt.pkAttempt FROM attempt WHERE attempt.ipaddress = '#cgi.remote_addr#' AND attempt.type = '#attributes.type#' AND attempt.dtAttempt BETWEEN DATEADD(hh,24,GETDATE()) AND GETDATE() It's not throwing an error, but it's not returning results that it definitely should be, either. Can anyone see where I'm going wrong? (SQL Server 2000) Thanks, Kay. ______________________________________________________ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Level 9/105 St George's Terrace - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au http://developer.perthweb.com.au - Tools for Developers cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
