some queries are only 1 day long if the user is at the beginning of the day