I’ve created a BAQ / Dashboard to show items being placed in the QA Rack . Parts clocked into an Operation created before any QA related OPR . These are active transaction to be shown and refreshed every 5 minutes . I am trying to show the duration on the parts sitting on the Rack . Epicor support suggested to use DateDiff , but that function is not applicable in E9 . I’ve tried the below with no success . If anyone could point me in the right direction would be much appreciated
- String(Time, “HH:MM:SS”) - LaborDtl.DspClockInTime
- Add-interval(String(Time, “HH:MM:SS”) , 20, ‘minutes’) - [Calculated field]
- String(Time, “HH:MM:SS”) = DataType Character
- LaborDtl.DspClockInTime = DataType Character
The whole idea here is to show the Time Duration of the parts sitting on the rack in minutes . System current time - Clocked in Time
Create the Row Rule to show example: Parts been sitting on the rack for 20 minutes = Warning . Parts been sitting on the rack for 30 minutes = Error
Thanks for any help . Appreciate it.
I’ve tried creating 3 calculated formula as below and analyse systax OK but when test i gotten error
Analyse Syntax OK
Having sore eyes with this simple function . Any thoughts ?