SharePoint – [Today] to include Time in Filter View

Problem: You have a SharePoint List.  You want a view of the list that filters items based on a time not aligned with the 24-hour “Today” time period.  For example, you want to see items created between 10:00am yesterday and 9:59am today.

Solution:

  1. Create a new column in the list for “EndDate”
  2. Create a workflow
    • set the time 10:00am for “Today” as the variable “Start Time”
    • add 1 day to “Today” and set that day to the variable “Today Plus One”
    • set the time 9:59am for the variable “Today Plus One” and assign to the variable “Todays End Date”
    • Set the “EndDate” column created in step one to “Today’s End Date”
  3. Create a view that filters the data to only show items where “EndDate” is greater than Today.
  4. Edit the view in SPD to include Time: <Value Type=”DateTime” IncludeTimeValue=”True”>

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s