How I can do datediff in Metabase?

Get Help
1

Hello everybody,
I'm trying do datediff because I need find the averange between difference but the result are string like this:

Screenshot_2
Screenshot_2941×61 3.88 KB

How I can do this?

2

Hi @leonardo96
That is currently not possible:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post

1 Like
3

Hi, @leonardo96
I had the same problem, but I wanted the age.
I made this:
SELECT
(DATE_FORMAT(NOW(), "%Y") - DATE_FORMAT(borndate, "%Y")) AS age