SharePoint: Filtering by a Date Value

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.
GordonRaeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
HairbrushConnect With a Mentor Commented:
Try [Today]-30 (no spaces)
0
 
HairbrushCommented:
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
 
GordonRaeAuthor Commented:
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
 
GordonRaeAuthor Commented:
Fantastic! Hirbrush, you have a strange name, but you do know your SharePoint. Big Thank you!
(This works)
 This Works
0
 
GordonRaeAuthor Commented:
Thanking you! hairbrush....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.