Solved

SharePoint: Filtering by a Date Value

Posted on 2011-03-10
5
473 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…

828 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