We have data dumped into a table weekly, and we're running reports to see how long issues are taking to be resolved. I don't see what the issue is here, but a query is not returning the latest date (which was run 9/15). Instead, it returns 9/8. Here's a scaled down version of the query, and it's not working.
SELECT Max(Problem.[DATE ENTERED]) AS MaxDateEntered, Problem.Name
FROM Problem
GROUP BY Problem.Name;
Thanks for any guidance.