SOLVED
Calculate age from DoB
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bbaisil
7 - Meteor
03-01-2022
05:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, How can I calculate age from date of birth ? DoB is in date time format
Solved! Go to Solution.
Labels:
4 REPLIES 4
gabrielvilella
14 - Magnetar
03-01-2022
05:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @bbaisil, you can use this expression in the formula tool:
DateTimeDiff(DateTimeNow(),[DoB],'years')
21 - Polaris
03-01-2022
05:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bbaisil
We can use a formula tool as below.
03-01-2022
06:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked. Thank you
21 - Polaris
03-01-2022
06:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bbaisil
Glad it helps and thank you for the accept mark. 😁
