EmployeeID EmployeeName ReportingTo lastweek
2022 Sam John 2013-05-22
weekly table Structure is
Employeename EmpId SubWeek ReportingTo Submitstat
Sam 2022 2013-05-10 John Approved
Sam 2022 2013-05-22 John Submitted
if you see EmployeeName sam has not submitted his timesheet for 2013-05-17 that is in between 10-22 May, I am trying to get that info, search those employees who have not submitted there timesheet for a given week.
I update the employeedb table with last submittion date as in above latest timesheet submittion date is 2013-05-22 so everytime when a employee submits this date gets changed in lastweek field to latest one.