<div>
thanks changed criteria to include the time:<br />
<br />
where CreatedDate&gt;= '2016-07-01 00:00:00.000'AND CreatedDate&lt;= '2016-07-30 00:00:00.000'
</div>


<div>
it isn't necessary to include the time, but if you do I also suggest you include the letter T which make the string into a &quot;safe format&quot; that SQL Server will always interpret correctly regardless of database settings.<br />
<br />
where CreatedDate&gt;= '2016-07-01T00:00:00.000' AND CreatedDate&lt;= '2016-07-30T00:00:00.000'<br />
<br />
it is much simpler to use YYYYMMDD which is perfectly safe also (MS SQL will always interpret it as YYYYMMDD)<br />
<br />
where CreatedDate&gt;= '20160701' AND CreatedDate&lt;= '20160730'<br />
<br />
and the time is assumed to be at 00:00:00+00000000<br />
<br />
<b>HOWEVER<br />
Your date range is 24 hours short of a full month </b><br />
<br />
If you change to using &gt;= with &lt;&nbsp;like this:<br />
<br />
where CreatedDate&gt;= '20160701' AND CreatedDate&lt; '20160801' --&lt;&lt; less than 1st of next month<br />
<br />
now you get exactly one month
</div>


<div>
<div class="content wysiwyg-content">
How do I modify the createdDate (datetime) to just a date?<br />
<br />
CreatedDate<br />
2016-07-19 16:00:19.710<br />
<br />
The also use it in the Where clause:--WHERE CreatedDate &gt;='2016-06-01' AND CreatedDate &lt;= '2016-06-31'
</div>
</div>


How do I modify the createdDate (datetime) to just a date?

CreatedDate
2016-07-19 16:00:19.710

The also use it in the Where clause:--WHERE CreatedDate >='2016-06-01' AND CreatedDate <= '2016-06-31'

CONVERT DATETIME TO DATE

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.