Forum Discussion
Comparing User/Date/Time over 2 tables
We have an effort tracking system for Overtime and Standby. What I would like to be able to do is highlight a users overtime claims that were made when they were on standby, either the Start or End t...
I've decided to simplify this a little to allow me to find my own solution.
I have nested ifs to check is User booked OT and standby on same day, then to see if start time was before 8am or after 6pm.