Forum Discussion
MelauriePelland
May 19, 2023Copper Contributor
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...
ganeshsanap
May 22, 2023MVP
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.
MelauriePelland
May 23, 2023Copper Contributor
ganeshsanap You do realize you just gave me the exact same JSON I already had?
- ganeshsanapMay 23, 2023MVP
MelauriePelland No, look closely at the URLs.
You were using this schema URL:
https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json
and I am asking you to try using this URL instead:
https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json
The 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.
- Thomasw1964Aug 08, 2023Copper Contributor53 always 53 ... doesn't matter which json I use... frustrating
- Rob_ElliottAug 08, 2023Bronze Contributor
Thomasw1964 since my earlier post in this thread I have moved tenant, so I tried it again on a new list but, sorry, I still couldn't reproduce the result of 53, everything was correct:
Rob
Los Gallardos
- MelauriePellandMay 23, 2023Copper ContributorWell, whether a v2 was added or not, I get the same results.
- ganeshsanapMay 23, 2023MVP
MelauriePelland Are you still getting error related to $ref '/properties/attributes/class' after using v2 schema?
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.