Try this
select DATEADD(dd, 0, DATEDIFF(dd, 0,SubmittedOn)) as WorkingDate,DATENAME(dw, SubmittedOn) as DaName,
ClientID,EmployeeID
from dbo.tblEmployeeTimeCards where
and convert(datetime,convert(varchar(10),SubmittedOn,103)) between convert(datetime,convert(varchar(10),@From,103)) AND convert(datetime,convert(varchar(10),@To,103))
Happy Coding!
:)