Adjust Time difference
Posted on 2012-03-09
I have code to show if an employee was late for work. The code works and shows if the person was 1 minute late or later. Here is the code in part...
CONVERT(varchar(20), MIN(h.TimeIn), 100) AS Actual,
CASE WHEN s.TimeIn < MIN(h.TimeIn) THEN DATEDIFF(MINUTE, s.TimeIn, ISNULL(MIN(h.TimeIn), s.TimeIn)) END AS Tardy,
MIN(h.RecordId) AS RecordId
Now I need to change the report so employees only show if they are 2 minutes late or more. So I just added +1 to s.TimeIn above. When I run the report, people who use to show 1 minute late are no longer showing...that's great! But records that use to show 2 minutes late now don't show either. Only 3 and more. Is there some sort of format issue I'm missing?