In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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