I have a simple query that needs to be run each day for event that happened yesterday.
I was using the following but if I use a date range instead I get more results so mine is faulty, Ive tried CURDATE(), CURRENTDATE, etc nothing seems to get me the actual results. Any help is appreciated.. please see syntax problem below
where a.adm_ts >= DateAdd(Day, DateDiff(Day, 0, GetDate()),0)
I want all records from 00:00 to 23:59 for yesterday ..