question

dheeraj1981 asked Jun 4, '18

how to include date logic to exclude data by date

i need to implement below logic

Exclude the patients where patient date is on or 1 day prior to event date :

select [patient date], [event date] from stu_tbl

where [patient date] <> DATEADD(d, - 1, [event date])

and [patient date] <> [event date]

patients date will be multiple

will the above condition work?

sql server date-functions

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dheeraj1981 commented · Jun 04, 2018 at 12:48 PM

select patient,[patient date], [event date] from stu_tbl

where [patient date] <> DATEADD(d, - 1, [event date])

and [patient date] <> [event date]

patients date will be multiple

will the above condition work?

0 ·