Solved

Calculated columns

Posted on 2014-02-04
3
228 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
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…

822 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