how to get data between date and name

Question

hi

i m using the sql query but i got a problem
mu query is

 SELECT ID,Name,Address,phoneno,natureofcomplaint,Assigneng,engid,assignby,assignby_id,status,remark,assigndate,resolvedate,@fromdate,@todate FROM call_request_master WHERE CONVERT(VARCHAR(10),assigndate,101) BETWEEN @fromdate AND @todate AND Assigneng=@enggname

now i got a error in my C# code

the query understan as the date between date and Assigneng
so queri wron

i can not give the understand to query

i got data from database two date
and this data again filter by name

give me some idea
in sql procedure
help me

Nilanka Dharmadasa · Answer

Hi Sharma As I understand you want to filter data based on the two queries. Your query has a small mistake. Change your query as follows. SELECT IDNameAddressphonenonatureofcomplaintAssignengengidassignbyassignby_idstatusremarkassigndateresolvedate@fromdate@todate FROM call_request_master WHERE Assigneng = @enggname AND CONVERT(VARCHAR(10)assigndate101) BETWEEN @fromdate AND @todate

Nilanka Dharmadasa · Answer

Hi Sharma For @fromdate and @todate you should pass correct dates. You get this error when your dates are not valid. If you can paste your c# code here.

Dharmesh sharma · Answer

i alow the changes in query but get same error in C# code Error is SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999