<div>
Select Field1, Field2, CONVERT(VARCHAR, Field3, 101) As MyDate <br />
FROM MyTable<br />
ORDER BY Field3<br />
WHERE Field3 &gt;= '11/1/17'
</div>


<div>
SQL Server is telling me there is an incorrect syntax near where when I put it before the WHERE clause.
</div>


<div>
Ah, sorry. &nbsp;I have a DISTINCT in my select statement. &nbsp;Otherwise that would work.<br />

<pre><code class="code-1 nolinks" id="code-20-42048282-1"><span>Select DISTINCT Field1, Field2, CONVERT(VARCHAR, Field3, 101) As MyDate </span>
<span>FROM MyTable</span>
<span>ORDER BY MyDate, Field1, Field2</span>
<span>WHERE MyDate &gt;= '11/1/17'</span>
</code></pre>
</div>


<div>
lcohan's last comment is correct, as your requirements are to sort it in date format but display it in the custom mm/dd/yyyy format, which would be converted to varchar, which if sorted by that would be text sorted and not date sorted. <br />
<br />
WHERE MyDate &gt;= '11/1/17'<br />
do this instead, which will handle any regional settings<br />
WHERE MyDate &gt;= '20171101'
</div>


<div>
<blockquote>
Ah, sorry. &nbsp;I have a DISTINCT in my select statement. &nbsp;Otherwise that would work.
</blockquote>
Did you try lcohan's last comment? Is the one that should work. Your code can't work because the ORDER BY need to come <u>after</u> the WHERE clause. Also, you're missing to order by <b>field3</b> that has the date.
</div>


<div>
SWEATY<br />
FEET<br />
WILL<br />
GIVE <br />
HORRIBLE<br />
ODORS<br />
<br />
SELECT<br />
FROM (with JOINS) <br />
WHERE<br />
GROUP BY<br />
HAVING<br />
ORDER BY<br />
<br />
Good luck getting that out of your head.
</div>


<div>
Recommendation to close this question by accepting the above comment as solution.
</div>


<div>
<div class="content wysiwyg-content">
I write a SQL SELECT statement and formatting the date. &nbsp;I want to order it by the date.<br />

<pre><code class="code-1 nolinks" id="code-10-29009016-1"><span>Select Field1, Field2, CONVERT(VARCHAR, Field3, 101) As MyDate </span>
<span>FROM MyTable</span>
<span>ORDER BY MyDate, Field1, Field2</span>
<span>WHERE MyDate &gt;= '11/1/17'</span>
</code></pre>
<br />
The problem is that MyDate is sorting it by <br />
01/01/3000<br />
02/01/2017<br />
....<br />
11/01/2016<br />
<br />
I want the 11/01/2016 to appear first and then every other date in order after that.
</div>
</div>


I write a SQL SELECT statement and formatting the date.  I want to order it by the date.
(CODE)

The problem is that MyDate is sorting it by 
01/01/3000
02/01/2017
....
11/01/2016

I want the 11/01/2016 to appear first and then every other date in order after that.

SQL - ORDER BY Date that is converted to String

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.