Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Make a calculated field of each Sharepoint list item update

Avatar of k_harpaul
k_harpaul asked on
Microsoft SharePoint
5 Comments1 Solution1826 ViewsLast Modified:
Hi.

I have a SharePoint list where a person can add information. In one of the fields the user enters a date. We can call this field "Capture Date". I would like to add another field (we can call this "Days In Progress") that calculates the number of days that has passed since the capture date was entered. IE: "Current Date-Capture Date". I would this field to be dynamic.

The problem that I have is that the "Current Date" does not change everyday unless an item is edited. I did have a look on this website and a similar question was posted before. The url is: "https://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_24086473.html"

Is there a way that this can be done? I am open to any solution even Workflows or adding a refresh button somewhere that will update all items in the list to that I get a correct "Days in Progress".

ASKER CERTIFIED SOLUTION
Avatar of Rajendra Shekhawat
Rajendra ShekhawatFlag of India imageSolution Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers