SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,'09/07/2013'))),DATEADD(mm,1,'09/07/2013')),101)
DECLARE @dtDate DATETIME SET @dtDate = '09/07/2013' SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))
DECLARE @dtDate DATETIME SET @dtDate = '8/18/2007' SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0)) LastDay_AnyMonth ResultSet: LastDay_AnyMonth 2007-08-31 23:59:59.000
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)