title: Error: Conversion failed when converting datetime from character string .NET SQL Server
body: <p>I realise this question has been asked before, but after going through the previously answered questions, i still can't quite figure out what's wrong with this code.</p>
  
  <p>FYI I am in the UK.</p>
  
  <pre><code>   public static void GetDataForCSEP(string viewName, string schemaName, 
                                               string dateFieldName, DateTime startDate, DateTime endDate)
          {
  
              string dateFormat = "yyyy/MM/dd HH:mm:ss";
  
  
              //Connect to SQl Server 
  
              string commandText = "SELECT * FROM " + schemaName + "." + viewName + " WHERE @dateFieldName BETWEEN @startDate AND  @endDate";
  
  
              using (SqlCommand sqlCmd = new SqlCommand(commandText,sql_Conn))
              {
                  sqlCmd.CommandType = CommandType.Text;
  
                  sqlCmd.Parameters.Add("@dateFieldName",SqlDbType.NVarChar, 30).Value = dateFieldName;
                  sqlCmd.Parameters.Add("@startDate", SqlDbType.DateTime).Value = DateTime.Parse(startDate.ToString(dateFormat));
                  sqlCmd.Parameters.Add("@endDate", SqlDbType.DateTime).Value = DateTime.Parse(startDate.ToString(dateFormat));
  
  
  
                  sql_Conn.Open();
                  sqlCmd.ExecuteNonQuery();
  
  
              }
  }
  </code></pre>