MelissaC
(Melissa Couture)
September 19, 2019, 7:55pm
1
Hi,
I am making a dashboard to be displayed on the shop floor. I am trying to calculate the time between operators logged into a job and the current time in my BAQ. TimeDiff throws an error that is it not an included function. Any ideas how to do this?
jgiese.wci
(Joshua Giese)
September 19, 2019, 8:00pm
2
(DATEDIFF(minute, DATEADD(minute, LaborDtl.ClockInMInute, '10/30/1953'), GETDATE()) / 60.00)
MelissaC
(Melissa Couture)
September 22, 2019, 7:21pm
3
Thank you so much. I did add +1 to the end to get the time to start at 0 instead of -1:00
A.Baeisa
(Al)
September 23, 2019, 8:45am
4
if you want to consider change in clocking in dates
@Mi3kel @gpayne @Nancy_Hoyt ,
i do not know if this will help to simplify what you want or not, and i have noticed that you are not taking into consideration the date change, and i think this is important when working on the LaborDtl table, so i created this SQL equation to calculate the difference in minutes time for each transaction between ClockInDateTime and CurrentDateTime, this one equation will take into consideration the different in days as well as time, and can be altered to any other …