How to return dates before and after the actual date

Abraham Olatubosun

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+"-3,120) And convert(datetime,'"+Textbox1.text+"+3,120)

any solution will be appreciated.

thank you

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
Try like below:
SELECT * FROM PatientVisit
WHERE visitdate BETWEEN DATEADD(day, -3, '" + Textbox1.text + "')
AND DATEADD(day, 3, '" + Textbox2.text + "');
+1
Tapan Patel9y ago
considering you have converted date time from your textbox, you can use below query.
SELECT * FROM YourTable
WHERE patientID=1234 and
(visitdate=DATEADD(dd,-1,converted date FROM Textbox)
  OR visitdate= DATEADD(dd,3,converted date FROM Textbox))
Please mark it as an answer if it addresses the issue.
+1
Nitin Sontakke9y ago
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
+1
Nitin Sontakke9y ago
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.
+1