As the title states I’m getting a result from my query that I didn’t expect at all. But it isn’t data, and the same query does return what I expected it to every other time except for the last row in the report.
Here is my query:
select ID, m.project,
m.part_number,
m.rw_date,
m.srw_reason,
m.erw_reason,
DATEDIFF(hour, p.user_starttime, p.user_stoptime) as hours,
DATEDIFF(minute, p.user_starttime, p.user_stoptime) as minutes,
DATEDIFF(second, p.user_starttime, p.user_stoptime) as seconds
from masterfabparts2 m, partsworkedon p where m.rw_date <= ? and m.rw_date >= ? and m.id = p.part_id_mf
Where my parameters are weekBefore
and today
. These parameters are set up thusly;
weekBefore: dateArithmetic(now(), -7, "days")
today: now()
The design of the table looks like this:
The design preview of the table looks like this:
If anyone has any insight into why this report is generating that way, or at the very least why it isn’t throwing a data-collection error like it usually does if my query is bad, I would really value your insight.
EDIT: Query has been changed slightly because I had noticed an error in what DATEDIFF() was actually doing compared to what I thought it was doing. The only result of this change is that hh:mm:ss is formatted and displayed correctly now. The last row, however, still results in an N/A half the time and this strange string the other half, and I have no idea why.