Variable Offset

Hello Guys,

i am working with variable offset's first time i need some help ,my client requirement is when we generate the query it automatically takes date, the date range is last month last date to yesterday's date. Using variable offset how can we do, Can some one tell me.

Thanks&Regards,

Krishna