Display data on a report
I have created a report called "Break Fix Dashboard design". I also have another table which consists of list of people for September month who are working on shifts. There are 3 shifts for each day and for each shift two employees will work.Timings for shifts are:
1st shift ( 6 am to 2 pm)
2nd shift ( 2 pm to 10 pm)
3rd shift ( 10 pm to 6 am)
I want to display the names of employees on my report, who are currently working, based on the current time.
For example if the date is Sep 23,2014 and current time is 9 PM, then it has to display the names of employees on my report, who are working at that particular time.
Can anyone please explain the procedure clearly.
Thanks in advance,