Forum Discussion
jensjakobsen1966
Jan 27, 2022Brass Contributor
Date calculation on SharePoint lists between today and a birthdate
Hi I've tried to calculate the age of a person based on 2 columns (NO success at all) on a SharePoint list. Therefore I need help, from the ground: Birthday column is a DATE column Today's ...
- Jan 27, 2022
jensjakobsen1966 there are a couple of ways to do this. One is with a flow in Power Automate that runs once a day and does the calculation. Another is to have a number column and format it with JSON as follows:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=floor((Number(@now)-Number([$Birthday]))/(1000*60*60*24*12)/365*12)" }
The result is:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Bo_Li_Cheng
Jan 10, 2023Copper Contributor
RobElliott
I used the exact same thing but every result returned 53. Are there some other settings I may have missed?
Edolop67
May 10, 2023Copper Contributor