Solved

SharePoint 2013 Column Calculation

Posted on 2015-01-27
2
161 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

860 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