show between two dates data with the help of column name wise

See more:

SQL

dear all,

i want to show between two dates data with the help of column name wise using sql server
i tried many other ways but am not. so please guide me for my solution.
please guide me is this possible to get output for the below query?
for example:

declare @fromdate datetime,@todate datetime
select @fromdate='2015-11-06 11:59:48.000', @todate='2015-11-11 13:22:27.000'

select *  from BillDetails1 where ProductName ='chokalate' between @fromdate and @todate

but am unable to get the result, on behalf of that am getting the below error,

error:

Incorrect syntax near the keyword 'between'.

thanks in advance..