Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint 2013 Column Calculation

Posted on 2015-01-27
2
Medium Priority
?
198 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_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
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 …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

609 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