Calc for Getting a fields name

[aapl]

Hi guys I have a problem which I am sure is easy to solve when you know how!

I have three Date Fields named: LastAppointment, RebookedSince, and Cancelled

My calculation field needs to display the name of the field with the greatest date in.

So for example if (dates displayed DD/MM/YYYY):

LastAppointment = 01/01/2011

RebookedSince = 02/01/2011

Cancelled = 03/01/2010

My calculation field would need to display "Cancelled" as that is the field with the greatest date. It also needs to ignore any empty fields

Hopefully someone can head me in the right direction here,

Many thanks!

[David Jondreau]

Let( [

m = Max ( LastAppointment ; RebookedSince ; Cancelled ) ;

result = Case ( LastAppointment = m ; "Last" ; RebookedSince = m ; "Rebooked" ; Cancelled = m ; "Cancelled" ) ] ;

result )

[aapl]

Let( [

m = Max ( LastAppointment ; RebookedSince ; Cancelled ) ;

result = Case ( LastAppointment = m ; "Last" ; RebookedSince = m ; "Rebooked" ; Cancelled = m ; "Cancelled" ) ] ;

result )

Thank you! This works perfectly.

If you have time would you mind explaining to me what it actually means in non calculation terms?

Many thanks.

[David Jondreau]

Find the highest value of the three fields.

Compare that value to each of the three fields.

When there's a match, return the specified text.

Let() permits you to define variables in the calculation.

Max() checks a set and pulls the highest value.

Case() tests and returns results.

[comment]

My calculation field needs to display the name of the field with the greatest date in.

What if there is a tie?