Operation Lead Time

Epicor ERP 9
1

I wanted to calculate lead times for each operation on a job. I tested it first with just the JobOperations table using: JobOper.DueDate - JobOper.StartDate which worked fine. But then I added the same calculation to a more complex query I get:
** Incompatible data types in expression or assignment. (223)

Any ideas?

2

Hey Randy,

Are you sure that the dates are not null?

Mark W.

3

Ah yes. Maybe. I’ll check.