Ex: Today's date is Feb 4, 2019. My birthday is Feb 5, 1998. On my Calculated Value, it shows 21 years old already. My question is how can I show it as 20 years old because it is still not Feb 5.
This is my current Formula: Datediff(day,[@Date_of_birth],GetUTCDate())/365
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
JanineB
How can I get the exact age:
Ex: Today's date is Feb 4, 2019. My birthday is Feb 5, 1998. On my Calculated Value, it shows 21 years old already. My question is how can I show it as 20 years old because it is still not Feb 5.
This is my current Formula: Datediff(day,[@Date_of_birth],GetUTCDate())/365
I wanted it to be based by day.
Appreciate your help!
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.