Can't do query: select startdate as orderdate, convert(char(10),getdate()) as gd, convert(char(10),startdate,104) as startdate, convert(char(10),enddate,104) as enddate, event from calendar WHERE startdate >= '2009-07-01' ORDER by orderdate ASC