[SQL] How can I get the last 12 months from the current date PLUS extra days till 1st of the...

Getting the last 12 months from a specific date is easy and can be retrieved by the following command in SQL-server. Its answer is 2014-08-17.

select Dateadd(Month, -12, '2015-08-17')


What I want is to get the last 12 months but ending at 2014-08-01 (in the above case) instead of any where in the middle of the month.

Continue reading...