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.

@brianwilson
It's not possible with the built-in Minimum/Maximum:
https://github.com/metabase/metabase/issues/4482 - upvote by clicking :+1: on the first post

1 Like

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!

Our metabase's version is v0.40.2 And I can't set maximum function in the custom expression with date(or timestamp) fields. Is there a better solution to solve it by now? thank you!

@francis123 There's currently no way to do this in the GUI. You would have to use SQL.

OK,thanks a lot.I remember it works(maximum date fields) in version v0.25.2 .

pic2

@francis123 Perhaps. 0.25.2 is several years old.

LOL! Can this function be restored to v0.25.2, because this is very useful.:joy:

@francis123 That's what the issue is for:
https://github.com/metabase/metabase/issues/4482 - upvote by clicking :+1: on the first post

Looking forward to solving this issue as soon as possible :rofl: