Any idea why this query of query: SELECT ProjectTaskID, Task, SchedStartDate, SchedEndDate, ActualStartDate, ActualEndDate FROM MyProjectList GROUP BY ProjectTaskID, ReturnTaskOrder, Task, ParentTaskID, ProjectPhaseID, SchedStartDate, SchedEndDate, ActualStartDate, ActualEndDate HAVING Year(SchedStartDate) = Year(#ThisSquaresDate2#) AND Month(SchedStartDate) = Month(#ThisSquaresDate2#) AND Day(SchedStartDate) = Day(#ThisSquaresDate2#) ORDER BY ParentTaskID, ReturnTaskOrder
would result in this error: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Thursday, 17 March 2005 1:43 PM To: CFAussie Mailing List Subject: [cfaussie] Re: SQL Syntax Comparing Dates 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/ --- 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/
