I have a BAQ that needs the end time of the previous operation. I am having trouble combining the ClockInDate and the ClockOutTime into one datetime field so I can calculate elapsed time between operations. Any pointers?
I believe you can use LaborDtl.ClockOutMinute-LaborDtl.ClockinMinute to determine how many minutes each operation takes
Just order by JobNum,AssemblySeq,OprSeq
1 Like
You are having trouble because combining those fields is not possible, they are separate things.
ClockInMinute & ClockOutMinute are stored as minutes from Midnight “00:00:00” “Oct 30, 1953”, which is the birthday of an Epicor programmer called Orv Rehfeldt.
You can do what @Hally said to get the time taken, but if you want the actual time, you will need to do something like this in a calculated field:
dateadd(minute, LaborDtl.ClockInMInute, '10/30/1953')
2 Likes
The end goal is to know how long a part has been waiting to start the next operation. Can I turn ClockOutMinute into a date and time?
The field mentions a “Base” date but mentions the actual value nowhere… Got my Epicor idea for this week 
That’s what I just showed you…
1 Like