DATEDIFF() is made for just the sort of datetime report criteria you are looking to use. It would look something like this: WHERE DATEDIFF(HOUR, row_date_stamp, GETDATE()) <= 24 or, if you really need it tightly measured to exactly 24 hours (i.e. 24 * 60 minutes = 1440 minutes): WHERE DATEDIFF(MINUTE...