Hmm that's pretty interesting. I would comment stuff out in that internal query body until it works with the date.now(), even if that means nothing else is running except date.now(). Then uncomment things until you find a culprit, since you know date.now() does work in a similar different query.