Hari Sharma

  • Interests: Solving Analytical Puzzles, Making Friends, Movies

Function to calculate Month End Date

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'

3.2 (5)

2007-05-08 (first published: )

1,313 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

SSRS Report Parameters Interactive

By Morissette

Hi, I have a table that has a dept_id, sect_id, div_id, item_id, and description. ...

Please recommend me some documents about SQL ?

By LloydRice

I am working with a new field, which is SQL, do you know about...

The metadata could not be determined because statement

By rohitkocharda

Hi everyone, I am running into a \n issue and it seems like none...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers