The New Method
This allows us to use functions like RoundDown, DateDiff and UTCNow. So, to calculate the age of a contact, we can create a new column of the type ‘Formula’ and use the following formula:
RoundDown(DateDiff(Birthday, UTCNow(), TimeUnit.Years),0)And just like that, what was previously code, is now low-code 🙂
If you found this useful, consider subscribing to our weekly newsletter where we share more such tips, tricks and updates on Dynamics 365 and Power Platform.