I am trying to sum the value by date, here is the query i currently have, 

```
SELECT     SUM(LineTotalValue) AS Value, DateTimeCreated
FROM         SOPOrderReturnLine AS SOPOrderReturnLine 
WHERE     (AnalysisCode1 LIKE 'value%')
GROUP BY DateTimeCreated
ORDER BY DateTimeCreated desc

```

Here is the what what data looks like from the results of the query. 

```
 Value       DateTimeCreated

433.00  2015-01-26 15:36:28.723
135.00  2015-01-26 15:36:13.883
600.00  2015-01-26 15:28:14.957
0.00    2015-01-26 14:45:57.920
58.25   2015-01-26 14:45:21.080
39.08   2015-01-26 14:45:13.443
41.56   2015-01-26 14:45:07.010
99.80   2015-01-26 14:44:56.243
99.99   2015-01-26 14:44:48.590
75.00   2015-01-26 14:44:39.647

```

As you can see as the DateTimeCreated value has the times in it it wont count the value correctly what i want it to do is count based on the date, how to achieve this? changing the data or table design is not an option