Maximum on date field and Views aggregation issue
First of all, select "None" for "Thousands marker" to have a properly formatted timestamp value;
In the "REWRITE RESULTS" section you can override the output of the field.
Given I have the aggregated field "created" overriding the field would look as following:

{{ created |timestamp_format('Y-m-d') }}