Concat max dates of currently selected field value

[#1]

Hello,

My table is:

WH	Date1
WH1	01.01.2013
WH1	02.01.2013
WH2	03.01.2013
WH3	04.01.2013
WH3	05.01.2013
WH3	06.01.2013
WH4	07.01.2013

My goal is to show max date of currently selected Warehouses (WH)!

For selected WH3 and WH2 I want to see: Last record for WH3 - 06.01.2013, WH2 - 03.01.2013

For concat dates I've played with this(does not work):

Concat(Aggr(Date(RangeMax({1<WH={"$(=WH)"}>} Date1)),WH),',')

[swuehl · Accepted solution]

Try

=concat( aggr(WH & ' - ' & Date(max(Date1)),WH),', ')

[#3]

Thank you!