I need to pull rather simple time stamped data for first shift 7a - 7p and second shift 7p - 7a per day. I am using start hour. The second shift is a challenge due to 12a - 6a falling on a different day of the 7p - 7a shift. I need to somehow recognize one date plus the next date. I know we have a previous function but I cannot find anything on a next function.
Has anyone encountered this need and were you able to resolve it?
Thanks in advance,