#eomonth

In this SQL trick, we learn how to use SQL Functions – EOMONTH and DATEADD to find first day of last month. Book a private … source

How to use EOMONTH() to return the last day of the month and more in Excel

There’s more to EOMONTH() in Microsoft Excel than the last day of the month. Learn how to put it to use in your spreadsheets. Image: Rawpixel/iStockphoto Dates play a part in many spreadsheets, but they can be a bit mysterious, especially when Excel doesn’t offer a date function that returns exactly the value you need. Fortunately, the more you know, the easier dates are to work with. In this…

New Post has been published on http://www.varindersandhu.in/2012/04/16/sql-server-2012-eomonth-find-last-day-of-any-month/

SQL Server 2012 – EOMONTH - Find Last Day of Any Month

In SQL Server 2012, seven new datetime functions have been introduced. EOMONTH is one of them.  This is really useful function because many times we need to find the last date of month.

Syntax:

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

EOMONTH ( start_date [, month_to_add ] )

Find Last Day of Current Month

Example:

SELECT EOMONTH (GETDATE()) Last_Date_Month

Result:

Date ————– 2012-04-30 Find Last Day of Next Month

Example:

SELECT EOMONTH (GETDATE(),1) Last_Date_Next_Month

Result:

Date ————– 2012-05-31 Find Last Day of Previous Month

Example:

SELECT EOMONTH (GETDATE(),-1) Last_Date_Previous_Month

Result:

Date ————– 2012-03-31

One can also refer the alternative