I am running a Drupal 8.0.5, I have a content type called show which has fields title, an entity referenced called movie and a date time. I am trying to create a view of the latest shows of each movie. The initial view is like this which shows the movie and show time
I enabled aggregation. Aggregation functions i used are For movie - group results together and for datetime - maximum. The result is as follows
it just gives 2,016 as date time field where i was expecting Mon 03/21/2016 15:00:00. Are we not supposed to aggregate on date field? I thought since MAX usually works in database for timestamp, it is valid here also. Can anything be done to achieve this result?