Hari Sharma

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,307 reads

Blogs

More Azure Blob Storage enhancements

By

I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...

Daily Coping 25 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

A Byte of Redgate–Bonus Queso Recipe

By

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...

Read the latest Blogs

Forums

HTML Mail with more than one line in Resultset

By tutter

Hello all, i would like to send a html Mail with sql server. But...

AS Tabular and Sample Data in VS

By philipp

Hello all, I really need your help – I want to use the sample...

SSIS Export Flat File as Fixed Width

By Oscar_Boots

Hi Forum, I have a table that uses the script below to create fields...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers