Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

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

Asked By: Noemi Ayers Date: Apr 27, 2009 Category: Sharepoint Views: 378

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.

Tagged:how to filter on time and not just date for list items

4 Answers Found

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

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, 2009

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, 2009

Perhaps this will give you some ideas.

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

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

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.

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.