Selecting maximum date

[mmhmark]

I have four different date fields for each record and need to select the greatest date.

Date 1: 03/21/01
Date 2: 01/01/01
Date 3: 02/20/01
Date 4: 01/30/01

Formula would select 03/21/01

 

[synapsevampire]

Try:

datevar array MyDates := [{table.date1},{Table.date2},{table.date3},{Table.date4}];
maximum(MyDates)

-k

 

[mmhmark]

It worked but I had to use dateTimeVar.

Thanks for the quick response

 

[synapsevampire]

Makes sense if you had a datetimevar, note that your example data was a type date, not datetime.

-k