Solved

SharePoint 2013 Column Calculation

Posted on 2015-01-27
2
149 Views
Last Modified: 2015-03-14
Hi,

I am trying to calculate years of experience in the calculated column.  I would have someone enter in the year they started working and then calculate it to today.   WHat is the formula for this and do I need 2 columns?
0
Comment
Question by:Jack_son_
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 40573504
Hi,
this is not possible as the TODAY function is not allowed in calculated column formulas.
And this is by design as the value of the calculated field is persisted in the content database, therefore a re-calculation is only run when the list item changes.
There are two workarounds:
If you just need the value in a list view, you might use client script to virtually calculate the difference and update an empty field in  the list view (or virtually create an additional column) OR you use the client object model and generate a table inside a DIV to display the data.
Second alternative is to create a workflow which runs e.g. once a month / once a day and which loops over all list items, calculate the difference and updates the list item.

HTH
Rainer
0
 

Author Comment

by:Jack_son_
ID: 40579309
Thanks, I got it working, although how do I get the today updating daily?
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now