Solved

SharePoint: Filtering by a Date Value

Posted on 2011-03-10
5
467 Views
Last Modified: 2012-05-11
For a Sales Team, we have a "Quote Renewals"  with a "Quote Sent" and "Quote Expires" Date Fields.
Is this possible, to have the date column called "Quote Expires" (say 2nd march 2011) to filter a View so that the Sales Team can see what quotes are due for renewal in 30 days.
0
Comment
Question by:GordonRae
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35095054
Hi

Yes, you can create a column called "Quote Expires" and make it a "calculated" column and specify a formula like [Quote Expires]+30 (if quotes are valid for thirty days)

When saving the column, be sure to specify that the formula returns a "date and time" and then set the date and time format to "date only".

In your view, you would then set a filter of [Quote Expires] is less than or equal to [Today].  Your view would then show quotes that have just expired, or expire today.  Your view could hide the [Quote Expires] column, if you don't want the users to see it.

Does that help?
0
 

Author Comment

by:GordonRae
ID: 35095217
Hello Hairbrush, wee problem, sometime quotes can be valid for 1 year or 2yrs, no doubt some in between. I realise this is not as easy as it should be. Here's what I'm trying, and doesn't work :(
 filter
0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 250 total points
ID: 35095587
Try [Today]-30 (no spaces)
0
 

Author Comment

by:GordonRae
ID: 35096101
Fantastic! Hirbrush, you have a strange name, but you do know your SharePoint. Big Thank you!
(This works)
 This Works
0
 

Author Closing Comment

by:GordonRae
ID: 35096110
Thanking you! hairbrush....
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

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 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