Skip to main content
Best answer

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

  • February 9, 2023
  • 3 replies
  • 182 views

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 

Best answer by DancingMachine

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.

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 9, 2023

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


  • Author
  • New
  • Answer
  • February 10, 2023

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.


jesse
Forum|alt.badge.img+9
  • Architect
  • February 10, 2023

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