Solved

Calculated columns

Posted on 2014-02-04
3
229 Views
Last Modified: 2014-02-04
I have a few date fields and two of the are "AssignToAnalyst" and "ResponseDate".
My calculated column called "days" calculates as "=[ResponseDate]-[AssignToAnalyst]".

In my list, the days are not calculating with the correct numbers.

I need to show  all log records over 30 days in the fiscal year. (Once a year at the end of the fiscal year)

I also need to show a weekly log report of records over 30 days.

Any help would be appreciated.  Below is my list.

Though this is SharePoint 2010, the actual list I am to apply this to is SharePoint 2007.  Just testing in 2010.

http://isaac.issharepoint.com/Lists/Log/Log%20View.aspx
0
Comment
Question by:Isaac
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39833747
your site is password protected, however...
Try: DATEDIF(responsedate,assigntoanalyst,"d")
0
 
LVL 5

Author Comment

by:Isaac
ID: 39833800
Try now.
That worked!

Is there a way to capture all items over 30 days in the fiscal year?
0
 
LVL 29

Expert Comment

by:QPR
ID: 39833825
sounds like a job for a "view" where date between X and Y AND "days" > 30.
But that's a separate question :)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

790 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