i have getdata() = 'Aug 17 2010'
i need to take getdate() - 5 value into another variable

@var1 = 'Aug 17 2010'
@var2 = 'Aug 12 2010'


the source table has this data

Name Busdt
aet 8/13/2010
adp 8/14/2010
add 8/10/2010
gdd 8/11/2010
hig 8/15/2010


now, i need to retrieve all the records with busdt falling between var1 and var2

how do i do this?

Thanks in advance

Depending if you want the time portion
dateadd(dd,-5,getdate())
or
dateadd(dd,datediff(dd,'',getdate())-5,'')