try to use convert function to extract date from ur field select count(*) as [No Of Orders],convert(varchar,CreatedDate,103) as OrderedDate from inv_drugorder where convert(varchar,CreatedDate,103)='11/05/2007' group by convert(varchar,CreatedDate,103) if it is not working or showing some errors pls mail me:)
sdf