Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SharePoint 2013 Column Calculation

Posted on 2015-01-27
2
Medium Priority
?
205 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 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

578 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