Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
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