max date value

[sea]

Hello,

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   2.3.2016  |
| CUSTOMER 1   |   3.4.2015  |
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   9.2.2015  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

How can only show maximum customer dates in this form:

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

Thank you!

[mechanix85 · Accepted solution]

MAXDATE:=MAX([DATE])