Two ways WHERE Year(Date1 ) = year(getdate()) and Month(Date1) = Month(getdate()) and day(Date1) = day(getdate())
or my lazy method set dateformat dmy select * from x where date1=convert(datetime, convert(varchar, getdate(), 103)) Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service Phone RNH +61 2 49236078 JHH +61 2 49214193 Fax +61 2 49214191 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 17/03/2005 12:55:37 pm >>> Say I have a 2 dates in my SQL 2K database like: 2005-03-14 00:00:00 and 2005-03-13 00:00:00 What would my Where statement look like if I were to grab all records WHERE Date1 = TodaysDate OR Date 2 = TodaysDate? Thanks guys! Chad Who doesn't take enough time telling folk how much he appreciates them. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
