Forum Discussion
sea
9 years agoFrequent Visitor
max date value
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!
MAXDATE:=MAX([DATE])
1 Reply
- mechanix85Helper I
MAXDATE:=MAX([DATE])