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 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.
MelauriePelland
May 23, 2023Copper Contributor
Well, 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.
- MelauriePellandMay 23, 2023Copper Contributor
ganeshsanap Yes, the same error messages appears when using the v2.
- Thomasw1964Aug 08, 2023Copper Contributor
MelauriePellandI am also getting 53 as every age