Hi, I need to generate a list every 2weeks for records that DateOfFirstVisit is in multiple of 2 weeks from today's date. so, DateOfFirstVisit date part only, no time part, could be 2, 4, 6,. 8, 10, 12.... weeks from today's date. How can I do that? My current query is not working. Thank you.
select StudyId,accountKey,emailAddress from dbo.Patients
where DateAdd(wk,Convert(date, DateOfFirstVisit), 2) = CONVERT (date, GETDATE())