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

Usage

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.

Example

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

AggDatetime(‘max’, [Date])

Screen_Shot_2020-10-29_at_3.49.02_PM.png

 

Related Functions

CallDatetime