AggDatetime returns a datetime value when given a warehouse aggregate function and acceptable argument(s).
This function is the aggregation version of CallDatetime.


AggDatetime(function name, arguments...)

function name (required): The name of an aggregate function supported by your data warehouse. The function must return a datetime value.

arguments (required): One or more arguments to be passed to the warehouse function. All arguments must meet the warehouse function’s input requirements.


Uses the warehouse’s MAX function to find the maximum value in the group’s [Date] rows.

AggDatetime(‘max’, [Date])



Related Functions