Calculating days before birthday

Get Help
1

I want to create a field that will identify we are X number of days away from a user's birthday. How can I do that ? One thought was to create a field that takes in birth day, birth month and current year and then create a field that subtracts that field from the current date.

Any other thoughts or a better way to do it ?

Thanks!

2

Hi @Mak
You would currently have to do it in SQL - we're working on adding the functionality:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post
and https://github.com/metabase/metabase/issues/19274