Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

Calculated columns

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
Isaac
Asked:
Isaac
  • 2
1 Solution
 
QPRCommented:
your site is password protected, however...
Try: DATEDIF(responsedate,assigntoanalyst,"d")
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
Try now.
That worked!

Is there a way to capture all items over 30 days in the fiscal year?
0
 
QPRCommented:
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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now