fix date range query in daily report