Age column in Dataverse

[@RickCurtis]

Thanks for a great tip. Here is the formula If ( (Month(UTCToday()) > Month('Date of Birth')) || (Month(UTCToday()) = Month('Date of Birth') && Day(UTCToday()) >= Day('Date of Birth')), Year(UTCToday()) - Year('Date of Birth' ), Year(UTCToday()) - Year('Date of Birth') - 1 ) How would you do this in regards to another date? My case is I have People in Programs and there is a Program Start Date. I need to calculate the person's age when the program starts.

[@psylancestudios]

Works Great. Trying to wrap this in an another IF statement to check if the 'Date of Birth" is empty, return 0, else run your code. However, can't save the formula after. Any thoughts?

If( Or( Month(UTCToday()) > Month('Data de Nascimento'), And( Month(UTCToday()) = Month('Data de Nascimento'), Day(UTCToday()) >= Day('Data de Nascimento') ) ), Year(UTCToday()) - Year('Data de Nascimento'), Year(UTCToday()) - Year('Data de Nascimento') - 1 )

@@psylancestudios If(IsBlank(Month('Data de Nascimento'), 0, If( Or( Month(UTCToday()) > Month('Data de Nascimento'), And( Month(UTCToday()) = Month('Data de Nascimento'), Day(UTCToday()) >= Day('Data de Nascimento') ) ), Year(UTCToday()) - Year('Data de Nascimento'), Year(UTCToday()) - Year('Data de Nascimento') - 1 ) )

[@syedburhanalishah]

I have a question. Why TZI why not just Date Only?

[@taylormader7425]

Where is the link to the show notes? or the link to get the formula?

[@mewithsharepoint8543]

Please make some video in dataverse related to assigned to multiple users similar like SharePoint column multiple user selection

[@jamesfreel3160]

When does this calculate? Does it only calculate when the DOB data is updated so if my birthday was tomorrow it would be correct today, but fail to recalculate tomorrow so i would be forever young?

[@powerplatformboost]

It calculates anytime there is a retrieve of the info (in a view, query, fetchXML, etc.) So your age will increase, but like me, you might not be forever young, but you can remain timeless. :)

Scott Durrow Math 🤣 True story Nick.