We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculate age from DoB

bbaisil
7 - Meteor

Hi, How can I calculate age from date of birth ? DoB is in date time format

4 REPLIES 4
gabrielvilella
14 - Magnetar

Hi @bbaisil, you can use this expression in the formula tool:

DateTimeDiff(DateTimeNow(),[DoB],'years')

 

Qiu
20 - Arcturus
20 - Arcturus

@bbaisil 
We can use a formula tool as below.

0302-bbaisil.PNG

bbaisil
7 - Meteor

It worked. Thank you

Qiu
20 - Arcturus
20 - Arcturus

@bbaisil 
Glad it helps and thank you for the accept mark. 😁

Labels