Automatically show only data from today at 8:30pm to tomorrow at 7:00am.
I'm having a really hard time trying to figure this one out.
I currently have a report that, when run, will show a worker's schedule for today. I have a parameter that sets the schedule_date equal to BirtDateTime.now()
I have a team of night shift workers who need to see their schedule, which runs from 8:30pm to 7:00am the next day. They encounter problems with the current report, because it only shows them part of their schedule. Before or after midnight, depending on when they run it.
Lets say they run the report at 9:00pm on Monday night, then again on Tuesday morning at 3:00am. It needs to show the exact same schedule at both of those run times.