Cannot View Aggregate of Date / Timestamp


When trying to find the first or last row (or maybe using other aggregates), Date / Timestamp columns are not shown in the View dropdown after selecting an aggregate function such as min or max. Since Dates / Timestamps / Time are all numerical values, they should not be removed from this list, but they are currently removed like Text columns.


I am experiencing the same issue. I would like to be able to see the min/max date in my results.


Is it possible to get Max/Min dates returned in a query w/o using native sql? - Would be a useful function to have.


It’s not possible with the built-in Minimum/Maximum, but a work-around is by using Custom Expressions:


FYI - unfortunately my date fields (postgres Timestamps) are not displayed in the custom expression builder, however if I manually type them in it works - thank you!