Calendar Month Interval to view Opening and Closing Stock

Hi,

I have a requirement as stated below.

I want to view data from From( Calendar Month) - To (Calendar Month).

I want to view data for Opening Stock and Closing Stock.

To make it clear, please find example below.

User selection screen 04.2013 - 05.2013 i.e. April to May.

Opening stock= March Closing Stock

Closing Stock= May Closing stock

kindly revert back with your views.

April to Dec

Opening stock= March Closing Stock

Closing Stock= December Closing stock

Thanks

Shyam.V