Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to Filter on Time and Not just date for List Items?

  Asked By: Noemi    Date: Apr 27    Category: Sharepoint    Views: 2635

We have a web part that is set to pull from a list based onthe list
name and view name. In this list, we have added the Scheduled Start
and End Date publishing columns and are trying to build a view based on
these columns. When building the filter for the view, we select those
columns (which are date and time) and use <= and >= [Today](reserve
word). This filter works but only on the day. It excludes the time.

I have seen the hacks for calculated columns, but they do not appear to
work.

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Meenakshi Khochar     Answered On: Apr 27

What, exactly, are you trying to show in the views? Items older than
or newer than the current date?

 
Answer #2    Answered By: Latrice Henson     Answered On: Apr 27

I have an item in a list  that has a start date/time and end
date/time. When someone uses that view, I want to show only what is
in the approiate range. Right now it only using the date  and is
ignoring the time.

 
Answer #3    Answered By: Nidhi Tiwary     Answered On: Apr 27

Perhaps this will give you some ideas.

office.microsoft.com/.../HA011609471033.aspx

 
Answer #4    Answered By: Beatrice Serrano     Answered On: Apr 27

Were you ever able to get this to work? I too need to be able to
filter items  based on date/time. I can do it through XSLT but I am
trying to use the results in a KPI, and it is not using my filtered
items.

 
Answer #5    Answered By: Katherine Williams     Answered On: Aug 20

This was really helpful; gives you the exact code you need to put into your site.

nickgrattan.wordpress.com/.../

 
Didn't find what you were looking for? Find more on How to Filter on Time and Not just date for List Items? Or get search suggestion and latest updates.




Tagged: