+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Minimum / Maximum Aggregate functions for date fields

The aggregate functions minimum and maximum allow only numeric values.

I would need this aggregate functions for date fields too.

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 :).

Promoted to “planned” state