How to return dates before and after the actual date

Question

Hi my code masters Thank you for all the tips you've been sharing with me it has help my coding development. please i want to return records of patient three day's before and three day's after the Patient Visit date i tried using the below SQL statment it's not returning the right records Select * from PatientVisit where visitdate Between convert(datetime '+Textbox1.text+-3120) And convert(datetime' +Textbox1.text+ +3120) any solution will be appreciated. thank you

Manas Mohapatra · Answer

Try like below: SELECT * FROM PatientVisit WHERE visitdate BETWEEN DATEADD( day  -3 ' + Textbox1.text + ' ) AND DATEADD( day  3 ' + Textbox2.text + ' );

Tapan Patel · Answer

considering you have converted date time from your textbox you can use below query. SELECT * FROM YourTable WHERE patientID=1234 and (visitdate=DATEADD(dd-1converted date FROM Textbox) OR visitdate= DATEADD(dd3converted date FROM Textbox)) Please mark it as an answer if it addresses the issue.

Nitin Sontakke · Answer

Furthermore you cannot say +3 to a string. It needs to be converted first to datetime and then add 3 on server side. convert(datetime ' + textbox1.text +') + 3 Also make sure that the value you pass is in the format yyyy-MM-dd for accurate conversion to date. select convert(datetime '2016-11-09')+3 -- 9th November

Nitin Sontakke · Answer

You must be storing the result of the query in some string variable. If yes please provide the value at the time of execution (that you will get in debug mode). The string of sql as seen by the sql server.