Rolling 12 Months


I have been asked to provide data based on 'most recent rolling 12 months' and also 'prior rolling 12 months'. They may be simple concepts to many, but what is the difference between the two?

I understand it as if it were today, it would be 11/1/2017 through 11/30/18 (most recent) and 11/1/2016 through 11/30/2017. (prior)

Thank you.

yes, that sounds about right to me


if you want to know how to do the TSQL

heres the link