Minimum / Maximum Aggregate functions for date fields

[combit_Webmaster (combit Team)]

The aggregate functions minimum and maximum allow only numeric values.

I would need this aggregate functions for date fields too.

[jbartlau (combit - Jochen Bartlau)]

While your suggestion makes absolute sense, a workaround for the time being would be to use something like

JulianToDate(Minimum(DateToJulian(Orders.OrderDate)))

i.e. convert the date to a double, use the aggregate function on the set of doubles and then convert the result back to a date. Works like a charm :).

[jbartlau (combit - Jochen Bartlau)]

Promoted to “planned” state