I would like to run the report, those who work fulltime on weekdays.
Conditions to write a filter# if the table.Status= active (still working online) from the Friday on/before 7pm (table.start date) to Sunday 4pm on/after (table.end date) then I have to display his records
Condition#If the user start at Friday after 7pm and logsoff before Sunday 4pm then I need to eliminate his records
Note: IF the user starts working from Friday (startdate with variable timings) definitely the user will quit sometime around either Saturday or Sunday late night
I am using the, Table.Status, Table.startdate and Table.end date fields.