Displaying value for the last occurence

[#1]

Hello,

I am trying to return values only for the last date occurence. For example, if a rep made a call to a customer last year it will return scenario 1 , however, if we made another contact to the same customer this year, it will return scenario 2. I want to return a scenario only for the max date.

Date, Policy #, Scenario

12/10/2011, ABC123,1

12/11/2012,ABC123,2

Please help. Let me know if you have any questions.

Thank you,

[CELAMBARASAN]

Check with FirstSortedValue function

FirstSortedValue(Scenario, -Num(Date))

[sujeetsingh]

You can use min(Date-today)