Question
How to calculate age from the date of birth.(Example)
Today : 2022/06/15
Date of birth : 1996/04/21
Age : 26
Last Modified Date: 16 Jun 2022
(Example)
Today : 2022/06/15
Date of birth : 1996/04/21
Age : 26
Environment
- Tableau Desktop
Answer
1. Connect to Sample(Birthday).xlsx from Tableau Desktop2. Create a new calculated field as following.
Name : Age
Calculation : IF DATEADD('year', DATEDIFF('year', [Birthday], TODAY()), [Birthday])> TODAY() THEN
DATEDIFF('year', [Birthday], TODAY())-1
ELSE
DATEDIFF('year', [Birthday], TODAY())
END
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials