Grouping events that go into the following day problem?
I am trying to flatten out an employees events for the day into a single line item in the load script. The problem is when an employee goes over the midnight hour into the next day. I want to have all records based on their initial login date.
If I attempt to sum grouped by EmpID and Date(Floort(Datetime)) it places events into the next day which is incorrect.