TSQL End of Current Month

select dateadd(m, datediff(m, 0, dateadd(m, 1, getdate())), -1)

Leave a Reply