shouldn't it be -24 otherwise you are looking for anything between now and 24 hours FROM now which would not pull any results. Kelly
-----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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
