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 do I fix this?
{
"$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)"
}
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?
MelauriePelland If you are using SharePoint online, use below schema in your JSON:
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",Example:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=floor((Number(@now)-Number([$Birthday]))/(1000*60*60*24*12)/365*12)" }Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap You do realize you just gave me the exact same JSON I already had?
MelauriePelland No, look closely at the URLs.
You were using this schema URL:
https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.jsonand I am asking you to try using this URL instead:
https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.jsonThe first URL/schema is required for SharePoint 2019 and the v2 schema is used for SharePoint online.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
