What specifically do you want returned, the more specifc you can be the easier it is for people to help..

do you want one row for each date in the previous month ?

or a one row output with '1 Nov - 30 Nov' ?

or something else.