December 16, 2011

last date of previous month from todays date

Select DATEADD(day,-1,DATEadd(MONTH,datediff(month,0,getdate()),0)) 

No comments:

Post a Comment