Find Last day of the month

To find the last day of the month in SQL:

—-Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
LastDay_PreviousMonth
—-Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
LastDay_CurrentMonth
—-Last Day of Next Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

Source: here

Learn 3dMax, Adobe etc Online

Website: lynda.com

Need to pay $25 but unlimited, with video quicktime and a good teaching structure.
if you signed up with premium, practice file will be given.