Hi
Please try this one
select * from tblcustomers where convert(datetime,currentDAte,105)
between convert(datetime,STUFF(STUFF(@currentDATefrom,3,0,'-'),6,0,'-'),105)
and convert(datetime,STUFF(STUFF(@currentDATeto,3,0,'-'),6,0,'-'),105)
This is not a preferable solution please make your database change as per above comments.