Calculating days before birthday

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 ?


Hi @Mak
You would currently have to do it in SQL - we're working on adding the functionality: - upvote by clicking :+1: on the first post