Ariel,

There *is* a maximum date function.

For example, in the Pivot view, using the Value drop-down to choose the Date field (you may need to change the drop-down's filter from "Numerics" to "Dates"), then in the Value > Function submenu, choose "Maximum".

In the content view, click edit, and choose Insert > Function. Again, choose the Date field, and pick "Maximum". This will insert a formula, equivalent to...

In formulas, use "SUBSET_MAX([DateField])". See http://www.visokio.com/kb/subset-functions for more information.

Steve

Thanks Steve,
but I am talking about a maximum date function across different date fields.
What you are talking about is finding the maximum date across multiple rows but one field. I want to find the maximum date across 1 row but multiple fields.

For example:For a single trade counterparty(1 row)
I have the following 3 fields:
last FX trade date
last Bond trade date
last Money Market Trade date

and I want to create the field "last trade date" by calculating the maximum across the above 3 fields.

The formula "MAX(number1,number2,...) " works for numbers but not for dates. My suggestion is to then adjust this formula so that it works for dates too.

OK, so you're talking about making the MAX(a, b, c) formula function applicable to dates. It's on the list.