Calculate age from two date columns using workflow

(0) Share

Report

Posted on by blatnjak_b

Hi!

I have a Dataverse table called "Wills". There are two date columns: bb_deceaseddate, and bb_birthdate.

When I add a new person into the database, I enter their birthdate. Once they are deceased, I have to enter their deceased date. When I do that their age of passing should be shown in a column bb_ageatpassing.

I was using a calculated column approach, which worked fine, but I was instructed that I have to use workflows or a Power Automate Flow, so the column can be used for the reports purporses.

Can anyone help me with this? Thank you. Regards, Bran

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Hello,

It would require custom workflow activities for this to be used in regular workflows. As far as I remember there is no DateDiff functionality in OOB workflows.

I would recommend using Power Automate Flow.

The design should be the following - on update of Deceased Date use DateDiff, extract the number of days and then divide by 365.25. Check this post - https://www.linkedin.com/pulse/date-difference-power-automate-david-adediran/

Was this reply helpful? Yes No
blatnjak_b 10 on at

Like (0)

Report

@a33ik That's what I suspected. Power Automate is the only option I have. Thank you for your help!

Was this reply helpful? Yes No