title: How to circumvent error Message 241 (Conversion failed when converting date and/or time from character string)
body: <p>I am simply trying to sort by my acquisition date column that has dates in this type of format: <code>'04/02/2019'</code> etc...  I have created and column named <code>ACQ_DATE_CONVERTED</code> in an new table and I usual get the results such as: <code>2019-04-02</code>. Instead I am getting the </p>
  
  <blockquote>
    <p>error Message 241 (Conversion failed when converting date and/or time from character string)</p>
  </blockquote>
  
  <p>I have tried the following:</p>
  
  <pre><code>SELECT [ITEM], [ACQ_DATE],
  
  CONVERT(DATE,[ACQ_DATE]) AS ACQ_DATE_CONVERTED
  ,'    ' AS MFG
  INTO [ABC].[dbo].[My_Store_records_CONVERTED]
  FROM [ABC].[dbo].[My_Store_records]
  </code></pre>
  
  <p>After my results I then order by <code>ACQ_Date_Converted</code>.</p>
  
  <pre><code>SELECT [ITEM], [ACQ_DATE]
  FROM [ABC].[dbo].[My_Store_records_CONVERTED]
  ORDER by [ACQ_DATE_CONVERTED]
  </code></pre>
  
  <p>My expected results should look something like this in the table:</p>
  
  <pre><code>       Column_A    Column_B       ColumnC
  Rows   ITEM        ACQ_DATE       ACQ_DATE_CONVERTED
  1.     ITEM_1      04/09/2007     2007-04-09
  2.     Store item  01/26/2008     2008-01-26
  etc...
  </code></pre>