Forum Discussion
Cindy Zalme
Oct 19, 2017Copper Contributor
SharePoint Online Date Calculation
I'd like to calculate the number of days between [today] and the due date in a SharePoint Online task list. Not sure why this seems so difficult or why I can't readily find an answer online. Any id...
CindyZ
Jun 27, 2018Iron Contributor
Thanks very much for this and especially your explanation. I did some quick searching but was not able to quickly ascertain why it is returning NAN even though my column is formatted as a number.
Pavel Sheludkov
Jun 27, 2018Brass Contributor
Good to hear.
I was first trying to use the calculated column but then realised that JSON formatting is much easier approach.
Also, if you haven't installed this amasing tool for working with JSON formating yet, do it.
https://thechriskent.com/2017/12/21/column-formatting-client-side-web-part-column-formatter/
I was first trying to use the calculated column but then realised that JSON formatting is much easier approach.
Also, if you haven't installed this amasing tool for working with JSON formating yet, do it.
https://thechriskent.com/2017/12/21/column-formatting-client-side-web-part-column-formatter/