Simple TSQL get the last day of next month time 00:00:00.000

dateadd(m, datediff(m, 0, dateadd(m, 2, @MyDate)), -1);

Leave a Reply