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!
You may try this formula as well.
(CASE WHEN DATEADD(YEAR,DATEDIFF(YEAR,[@field:Date_of_Birth],GetDate()),
[@field:Date_of_Birth]) > GetDate()
It worked in almost all scenarios, considering leap year, date as 29 Feb, etc.
Hope this helps.