There is a field in JobOper for the last labor on an operation and this displays as a date. Specifically the field is JobOper_LastLaborDate. Does anyone know how I can gather the first labor date?
Link up the Labor_Dtl table. Add the column LaborDtl_ClockInDate. You should get a list of all the dates clocked for the op. You could then use a formula to take the minimum from that field.
1 Like
OR (If you need to save this date), then you can create a UD field let say JobOper.FirstLaborDate, and a Data or Method BPM to be triggered at start Prod. or Setup activity (labor details table) ONLY if this UD field is blank " ", the BPM should stamp the ClockIn date of Labor table record for the first time only with the first logging date as it wont be blank afterward.
2 Likes