<div>
You want the real month end date or the max date in the month?<br />
<br />

<pre><code id="code-20-40864184-1">select max(date) from YourTable group by YEAR(Date), Month(Date)</code></pre>
</div>


You want the real month end date or the max date in the month?



select max(date) from YourTable group by YEAR(Date), Month(Date)

<div>
31/1/2002 &nbsp;is certainly a typo ...<br />
<br />
It looks like you need the last row found for each month. Or is it only the date itself?
</div>


31/1/2002  is certainly a typo ...

It looks like you need the last row found for each month. Or is it only the date itself?

<div>
I am just curious...<br />
<br />
Does the solution work for December?
</div>


I am just curious...

Does the solution work for December?

<div>
why don't you try, substitute any date in december in the [datefield] and found out the result for yourself.<br />
<br />
trying is one way of learning.
</div>


why don't you try, substitute any date in december in the [datefield] and found out the result for yourself.

trying is one way of learning.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a list of dates for example,<br />
<br />
1/1/2002<br />
1/2/2002....<br />
31/1/2002..<br />
1/2/2003<br />
2/2/2003..<br />
2/27/2003<br />
<br />
I want to create a temp table and select only those dates that are end of month for each year. I could have used <br />
select DATEADD(DAY,-1, '3/1/2003')) but this would have returned me 2/28/2003 but I need to get 2/27/2003<br />
How can i do this in sql. Can i use loop in sql?<br />
<br />
Thanks
</div>
</div>


Hi,

I have a list of dates for example,

1/1/2002
1/2/2002....
31/1/2002..
1/2/2003
2/2/2003..
2/27/2003

I want to create a temp table and select only those dates that are end of month for each year. I could have used 
select DATEADD(DAY,-1, '3/1/2003')) but this would have returned me 2/28/2003 but I need to get 2/27/2003
How can i do this in sql. Can i use loop in sql?

Thanks

sql end of month

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.

Microsoft SQL Server

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.