Return most recent date is a list
We have a number of employees in a list that I woudl like to return the most recent date they worked.
Forexample, we upload into a big table all of the hours. Then have them breakdown to separate stores so we know who is working where and how much etc...
What i Would liek to do is figure out a way to insert a columb that pulls the last day each employee worked. THis would help find out who quit without telling us etc...
Almost like max or min but have it match an employee ID number.