Summarize by max date

Question

I have been looking around the forum but I cant seem to figure it out

I have this table:

And I want to create this table:

Name	LastDate
Microsoft	03/01/2018

I am using summarize(table, name, "max",max(date)) but somehow I am getting 04/01/2017.

Its probably something obvious but I would appreciate your help

lukiz84 · Accepted Answer

Is "LastDate" formatted as text or as Date? There should be the problem 😉&nbsp;Format it as Date ...&nbsp;

Forum Discussion