[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Calculated columns

Posted on 2014-02-04
3
Medium Priority
?
240 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
[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
3 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

649 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