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: 3190

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



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.


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

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.


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.