Dates in text object

[apthansh]

Hi ,

I have few dates as belwo

ID     Date Type          Date

1       Renewal           11/10/2018

1       Cancellation     10/10/2020

1       Cancellation     10/10/2018

In Text object I want to show most recent date (min(Date)) on each date type.

Renewal - 11/10/2018 &'-'& Cancellation - 10/10/2018

Can this be done ?

Than you very much

[sunny_talwar]

May be this

'Renewal - & Min({<[Data Type] = {'Renewal'}>} Date) & ' -  Cancellation - ' & Min({<[Data Type] = {'Cancellation'}>} Date)

[antoniotiman]

Try this

=Concat(DISTINCT [Date Type]&'-'& Aggr(NODISTINCT MinString(Date),[Date Type]),Chr(10))