Retrieve records based on date

Hi
I would like to develop an application which retrieves records based on date.(using vb.net)
if initial date is 07/10/2010 expiry date is 07/08/2011(dd/mm/yyyy) which is stored in database.
between these two ranges on 07th of every month i wanna generate reports . 
and if if initial date is 15/10/2010 expiry date is 15/08/2011(dd/mm/yyyy) on every months 15th reports has to be generated.


So can anyone help me on how to implement the above.
...