Date Range Problems Need Help

Good Morning Team:

I am having a problem selecting from a range of date selected by the user using parameter declaration. I want to be able to select the records from ex. Feb 02, 2007 to Feb 05, 2007 list the records that ocurred on those dates.




Declare @Req_Contract_nbr char (8),
@Req_Begin_Day int,
@Req_End_Day int,
@Req_month int,
@Req_year int

Set @Req_Contract_nbr = 'GTH00001'
Set @Req_Begin_Day = '2'
Set @Req_End_Day = '5'
set @Req_month = '2'
Set @Req_year ='2007'

SELECT a.contract_nbr, SUM(c.dlvry_nom_vol)AS Deliveries,
MAX(c.beg_eff_date) As Selected_Date,MAX( c.rcpt_dlvry_ind ) AS Delivery_Type
from TIES_Gathering.dbo.contract a
Inner Join TIES_Gathering.dbo.NOm b on a.contract_nbr = b.contract_nbr
Inner Join TIES_Gathering.dbo.Nom_vol_detail c on c.Nom_id = b.Nom_id
where (a.contract_sub_type = 'INT') and (a.Contract_type_code ='GTH')
and (DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) < a.current_expirtn_date)
and (c.rcpt_dlvry_ind ='D') and a.contract_nbr= @Req_Contract_nbr
and Day(c.Beg_eff_date) Between @Req_Begin_Day and @Req_End_Day
and (month(c.Beg_eff_date)= @Req_month )
Group by a.contract_nbr



Data Example:

Contract_nbr ** Deliveries *** Date*** Delivery Type
GTH00001 389231.0 20070202 R
GTH00001 687680.8 20070203 D
GTH00001 608798.9 20070204 D
GTH00001 80980.5 20070205 R


This is the data that I am trying to record.

Thank you again to all of you for all your help.