Viewing post 1 (of 1 total)
The easiest way to do this is:DATEADD(mm, DATEDIFF(mm,0,getdate()-1), 0)
The inner part DATEDIFF(mm,0,getdate()-1) gets the number of months between yesterday and the date "1900-01-01 00:00:00.000". Then the outer...
February 17, 2017 at 6:33 am
#1929077