Answered

Calculating age from birth date and current date using Workflow Definition Language expressions

(0) Share

Report

Posted on by ras1000

If I have a date of birth (from a Microsoft form question) and have inserted it into an Excel table row, how would I calculate age using a Workflow Definition Expression which would be placed in an Excel table column beside the one for date of birth?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ras1000,

Currently it is not possible to use a datediff function in flow to count days between two days. There is a similar request on Flow Ideas Forum, please vote the idea at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/workflow-definition-language-needs-to-be-expanded/idi-p/24641

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Verified answer

ras1000 52 on at

Like (1)

Report
Copy link

Link copied!

I did manage to get age using ticks for the birthdate (from Microsoft Form field) and utcNow. After dividing by a couple of constants I was able to get age as a float.

Expression is: div(div(sub(variables('Today'),variables('Birthdate')),864000000000),365.25)

Variable Today is "ticks(utcNow())"

Variable Birthdate is "
ticks(body('Get_response_details')?['rde329303c5a04b32b9b9f35a0564400e']) based on Microsoft Form response field.

At the end of the day I did not go ahead with the calculation as the result is not dynamic, i.e. result does not change if someone has a birthday.

Was this reply helpful? Yes No