account for date not time in reports