I have a record that has active and CompletedImpForm both equal to true(or 1, they're bit) with
I try to run that just now and no record is selected. 5/15 - 5/1 , is 14 days then why didn't this record got selected? How to fix this? Thank you.
select StudyId,accountKey,emailAddress from dbo.Patients
where Datediff(d,getdate(), DateOfFirstVisit)%14 = 0
and Active=1 and CompletedImpForm=1