Number of years Based on a date

English Forum Tips and Tricks
1

Hi there! How can I set up an ‘age’ field based on a ‘Date of Birth’ field? I’m creating a form to collect information from potential candidates for several jobs. However, I need to know their age, as this is relevant for visa purposes (this is particularly for migrants in Europe). I would like candidates to fill out their Date of Birth, and I want to automatically calculate and display their ‘age’ in years in another field.

2

Welcome, @Miguel_Hernandez1,

If your plan supports Formula type custom fields, create one with this Advanced formula: ( ( [[$TODAY]] - [[$1206869070734003]] ) + 0 ) / ( 365.25 * 1440 )

That will show the age, though including a decimal.

Thanks,

Larry

2 Likes
3

Thank you very much!!! Works Great!! :smiley:

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.