Amount of days between "Due Date" and [Today] .. is it possible? RRS feed

  • Question

  • I was hoping that SharePoint could do this by default but then again there may be a way around it.  Essentially we have a custom list where a user can submit a milestone for a project, it's due date, and it's completion date.  They also wanted to be able to see how many days overdue the request was if there was no completion date which I thought would be easy by doing the following:


    =DATEDIF([Due Date], [Today],"d")


    .. and then creating a view to only show the "Days Overdue" column if no completion date was present.


    However, SharePoint states the following error message: A calculated column cannot use "volatile" functions such as [Me] or [Today].


    Am I out of luck or is there a possible workaround for this?

    Friday, October 12, 2007 4:31 PM

All replies