?
Solved

SharePoint: Filtering by a Date Value

Posted on 2011-03-10
5
Medium Priority
?
491 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
[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
  • 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 1000 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

752 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