C# .NET - I GOT THE ERROR DATA TYPE RESULTED IN OUT-OF-RANGE VALUE

HI,
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
my query is
Query = "SELECT DISTINCT WeekStartDate FROM TimeSheetBreakDown";
                Query += " Where Date >= '" + StartCalDate + "' AND Date<='" + EndCalDate + "'";
values
StartCalDate=22-07-2013
EndCalDate=25-07-2013

but value of Date in Table TimeSheetBreakDown in yyyy-mm-dd hh:mm:ss format.

use a datetime variable instead of a string. To create a datetime variable use DateTime.ParseExact method.

ex.

CultureInfo provider = CultureInfo.InvariantCulture;
format = "d";   
result = DateTime.ParseExact(dateString, format, provider);
Console.WriteLine("{0} converts to {1}.", dateString, result.ToString());
    

hey try by below way.  See the modified Where clause..
 
Query = "SELECT DISTINCT WeekStartDate FROM TimeSheetBreakDown";

Query += " Where Date >= '" + Convert.ToDateTime(StartCalDate) + "' AND Date<='" + Convert.ToDateTime(EndCalDate) + "'";