<div>
use this<br />

<pre><code id="code-8146540">declare @LastOfMonth DateTime
set @LastOfMonth = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
elect * from recordtable where date &lt;= LastOfMonth</code></pre>
</div>


use this


declare @LastOfMonth DateTime
set @LastOfMonth = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
elect * from recordtable where date <= LastOfMonth

<div>
<div class="content wysiwyg-content">
Hi,<br />
what is the date function I can use to select records which no more than date in the month. For example I run a select statement <br />
<br />
select * from recordtable where date &lt;30:04:2011 23:59:59:000'<br />
<br />
But using a date function I want when I assign the where clause sql will automatically detect end date for each month.
</div>
</div>


Hi,
what is the date function I can use to select records which no more than date in the month. For example I run a select statement 

select * from recordtable where date <30:04:2011 23:59:59:000'

But using a date function I want when I assign the where clause sql will automatically detect end date for each month.

Date function use to select record not more than date in month

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.