We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
21 - Polaris
21 - Polaris

@bbaisil 
We can use a formula tool as below.

0302-bbaisil.PNG

bbaisil
7 - Meteor

It worked. Thank you

Qiu
21 - Polaris
21 - Polaris

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

Labels
Top Solution Authors