I have been asked to create a BAQ that calculates average labor hours by job and part over a date range.
I need to add something, that in SQL would be Labor.Dtl.ClockOutTime-Labor.Dtl.ClockinTime>0
How can I accomplish this?
Here is my where clause in SQL; I need to know where to add the italicized line to the BAQ
and erp.jobhead.JobCompletionDate>‘01/01/22’ and erp.jobhead.jobcompletiondate<‘04/01/22’