Best answer

How do you create a zap based on a person's date of birth?

  • 9 February 2023
  • 3 replies
  • 128 views

Userlevel 1

How do you create a zap based on a person's date of birth?

We have customers that submit their information to us which include their date of birth. I’d like to create a zap so that a certain action happens (ex: a specific email is sent) if a person is age 18 or older.

Same if someone is between the ages of ex: 6-7 years old, or ex: under the age of 3 years old 

icon

Best answer by DancingMachine 10 February 2023, 16:23

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @DancingMachine

Good question.

Try adding Filter steps to your Zap: https://zapier.com/apps/filter/help

Paths can also be used, but required a higher Zapier plan: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

Userlevel 1

I found the answer from another community thread. 

https://help.zapier.com/hc/en-us/articles/8496308621197#1-add-a-formatter-step-to-your-zap-0-0

I took the date of the customer registration (i.e. today) and compared it to the customer’s date of birth.

You will then get an “output days” number. For ages 18 and up, the “output days” needs to be at least 6,570 days (365 days * 18 years).

Then I created a filter requiring that the “output days” is greater than “6,569”

Wah-lah, I can now perform an action for my customers that are at least 18 years old and older.

Userlevel 7
Badge +9

So glad to hear you got this one sorted, @DancingMachine and thanks for coming back to share your solution! 🙂