I am getting the error while executing  below code
   The dates are coming like below


   Where (EndDate >= '13 Nov 2017 0:0:00PM' and
   EndDate < Convert(DateTime, '13 Nov 2017 0:0:00PM')+1)

   The above is coming as a param value in the procedure
   Basically need to convert '13 Nov 2017 0:0:00PM' to datetime
   in the query.This is a `enter code here`filter condition in SP

Is the dates coming wrong in SP or can I change it to datetime inside
   SP body.