I got a result.. I just saving dates to database in 'dd/mm/yy' format and writing the following query to fetch the records..
select *from IvoiceDetails where convert(varchar(20),InvoiceDate,103)
between convert(varchar(20),frmDate,103) and convert(varchar(20),toDate,103)