I’m trying to create a Schedule software to count parts produced at line.
I have a table with name schedule, with the datetime column of startdatetime and enddatetime of shift.(DateTime)
Also have a table break, with time of break. With Start time and End time.(Time)
I’m trying to start a counter when the actual time from gateway is >= the startdatetime and <= enddatetime. Works great, But when trying to include another IF for the date and time need to be between the schedule and the hour diff from the break star and end time.
I try to use a dateFormat, but show a wrong time.
Has another option?