updating date count query to use hour for handling timezone better