Forum Discussion
Shift table w/Date changed to (Datetime) starttime / endtime from Date - reference
Shift table changed from Date and shift columns due to 12 hour shifts 7am to 7pm, 7pm to 7am to columns (Date/Time format) startTime and endTime and shift column. Before it had a relationship to Date...
We have 4 shifts (2 day shifts and 2 night shifts) and I want to query production losses by shift. It used to be the shift schedule was setup as Days - A/C shift and Nights - B/D Shift. I want to split it up into 4 separate shifts A, B, C ,D. Our data reference is setup by date only, not Date / Time. So when I create the relationship it duplicates A and C shift, and B and D duplicates the losses..