title: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.
body: <p>i am having problem with my retrieving of date after the date fall after 12. for example : if i click from the calander extender: 2/7/2013 to 19/july/2013 , is will throw it me with this error : The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.</p>
  
  <p>this is my code:</p>
  
  <pre><code>var format = "MM/dd/yyyy";
      DateTime one = DateTime.ParseExact(startdate, format, CultureInfo.InvariantCulture);
      DateTime two = DateTime.ParseExact(enddate, format, CultureInfo.InvariantCulture);
  
  
  
      if (two &gt;= one)
      {
          SqlConnection conn = new SqlConnection("Data Source=""catalog="";Integrated Security=True");
          conn.Open();
          SqlCommand cmd = new SqlCommand("SELECT Name,CLass, NRIC, StallNo, AmountSpent ,TimeDate=convert(nvarchar,timedate,103)  FROM StudentTransactions WHERE TimeDate BETWEEN '" + one + "' AND '" + two + "'", conn);
          SqlDataReader reader = cmd.ExecuteReader();
          GridView1.DataSource = reader;
          GridView1.DataSourceID = null;
          GridView1.Visible = true;
          GridView1.DataBind(); 
          conn.Close();
     }
  </code></pre>