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...
Matt Coats
Steel Contributor
The problem is SharePoint Online treats that as a calculation, and calculations are only refreshed when the item is modified in any way (at least, out of the box). The only way I could find to force the date to recalculate was to create a loop in SharePoint Designer or Flow to overwrite something in an item with its current value until due date = today, which technically changes nothing about the item while still counting as a modification, resulting in a refresh of a date difference calculation. It's an expensive workaround, especially on large lists with lots of due date items, but it's the only non-custom way I know of to manage this.
CindyZ
Oct 23, 2017Iron Contributor
Thanks, Matt...may not be beautiful, but that will work!