Calculated field to determine days remaining

Question

_{Monday, November 24, 2014 3:02 PM}

I have a calculated field in my list to determine days remaining before Due Date.  The field is displayed in the view.

It looks like this: =DATEDIF(TODAY(),[Due Date],"d")

I've seen it another list and each day the Days Remaining get decremented.  But in my list the number does not go down.  I have read that such calculated fields will only be updated when the item is changed but I see it happening in the other list.  What is the truth about calculated fields using TODAY()?  Can I use SP OOB  or  SPD 2010 workflow to get it to work the way I want?

All replies (3)

_{Monday, November 24, 2014 3:10 PM ✅Answered}

https://social.technet.microsoft.com/Forums/sharepoint/en-US/401f729e-bd35-43b7-b6d6-ff765cd51859/creating-calculating-column-to-know-the-days-remaining-before-due-date?forum=sharepointadminprevious

I understand that you want to calculate the days between today and [Due Date], but the result won’t change even if the date has changed. You can try below 2 method:

1. Use now formula:

Replace all “today” with “now()” in your formula such as: =(DATEDIF(NOW(),[Due Date],”d”))-INT(DATEDIF(NOW(),[Due Date],”d”)/7)*2-IF((WEEKDAY([Due Date])-WEEKDAY(NOW()))<0,2,0)+1

1. Use workflow:

Create a work flow and use “Find interval between dates”, then set certain field value to this variable. You can use information management policy to trigger the workflow. And you can set the frequency to daily. But you need more research to exclude the weekend days.

If this helped you resolve your issue, please mark it Answered. You can reach me through http://itfreesupport.com/

_{Monday, December 8, 2014 7:47 PM}

I am trying to use the "information management policy" to trigger the workflow but I don't think I have it set up right.  My goal is to have it run everyday after the item is created.  I think it is running every other day.  Here are my settings:

Event:  Time Period:  Created Date + 1 days

Action:  Start a workflow (and I provided the name)

Recurrence

"Repeat this stage's action..." Recurrence period 1 days

I created the item Friday Dec 5th and the workflow ran:

What should I be doing differently to get it to run daily???

_{Tuesday, December 9, 2014 9:10 PM}

If anyone could tell me the answer to the above that would be great.  Basically, how can I make the workflow in the Information Management Policy run daily?  Do I need to change something in Central Admin as well?