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?
Solved! Go to Solution.
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.
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:
Best regards,
Mabel Mao
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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
14 | |
4 | |
4 | |
4 | |
4 |
User | Count |
---|---|
13 | |
6 | |
5 | |
5 | |
5 |