Function to calculate Month End Date

By Hari Sharma, 2007/05/08

This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.
Example:
Input: '2-20-2004' Output: '2-29-2004'
Input: '2-15-2004' Output: '2-29-2004'
Input: '3-20-2004' Output: '3-31-2004'
Input: '3-30-2004' Output: '3-31-2004'

Total article views: 1238 | Views in the last 30 days: 5

SCRIPT

Month Name

Function to return the Month Name for month number input

FORUM

Merge Inputs Several Rows but no Output

Merge has Input but no Output

BLOG

A Month of PowerShell – Day 7 (Script Input/Output)

Welcome to Day 7 of my “A Month of PowerShell” series. This series will use the series landing page ...

ARTICLE

Stairway to SQL PowerShell Level 3: Input and Output with PowerShell

This level will cover some of the Input/Output operations you can use with PowerShell.

SCRIPT

Financial Month

This Script will return the respective financial month(Starts from April to March) for a calander mo...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com