Solved

Calculated columns

Posted on 2014-02-04
3
226 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
Comment Utility
your site is password protected, however...
Try: DATEDIF(responsedate,assigntoanalyst,"d")
0
 
LVL 5

Author Comment

by:Isaac
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now