change NOW() to '$reportdate 00:00:00'