Forum Discussion
Age according to DoB
I've tried using the following JSON formula to calculate the age according to the date of birth column but ever since I tried adding the formula to my pre-existing list, the age displays as 53. How d...
MelauriePelland sorry, I can't reproduce this; copying & pasting your JSON I get the correct results:
Make sure the Age column is a number column set to no decimal places.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
The age column is set as a number column with no decimal places already. I get this error message when I enter the JSON formula : $ref '/properties/attributes/class' in 'https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json' can not be resolved.(768)
Could that be the reason why it's not working for me?