Calculate the Date type to generate a Custom column

Hi,everyone,I have a problem that I need your help with.


This is a date-type data, I want to add a custom column to calculate the month difference between the current time and this date.I did not find a function in the document that can do this, how can I achieve this requirement?
Thanks everyone.

1 Like

Hi Jesse,
I think you'll have to go with Native SQL and use the date difference function of your SQL engine. For instance DATEDIFF('month',[the_date_field],Now()) with PostgreSQL.

Hi @jesse1
That's currently not possible with Custom Expressions:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post