BAQ Error : [Conversion failed when converting date and/or time from character string]

Epicor ERP 10
, ,
3

As it turns out, I can no longer perform a simple DATEDIFF() function between two date fields in the [Erp.LaborDtl] table; else those errors appear (even though my initial date range testing worked extremely well, without fail, even on previous BAQ/SSRS report solutions).

Here’s what eventually worked for me (my goal was to simply calculate clocked hours on an operation; and then separately, the remaining clocked minutes on the same operation):

Instead of:

Hours:
(DATEDIFF(n, LaborDtl.DspClockInTime, LaborDtl.DspClockOutTime) / 60)

Remaining minutes:
(DATEDIFF(n, LaborDtl.DspClockInTime, LaborDtl.DspClockOutTime) % 60)

… the only thing that worked for me was:

Hours:
(DATEDIFF(n, DATEADD(minute, LaborDtl.ClockInMinute, '1953-10-30'), DATEADD(minute, LaborDtl.ClockOutMinute, '1953-10-30')) / 60)

Remaining minutes:
(DATEDIFF(n, DATEADD(minute, LaborDtl.ClockInMinute, '1953-10-30'), DATEADD(minute, LaborDtl.ClockOutMinute, '1953-10-30')) % 60)