Solved

SharePoint: Filtering by a Date Value

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now