Filtering Sharepoint Lists on a Now or Today

Question

I m trying to find an effective method of filtering Sharepoint lists based on the age of an item   In other words  if I want to find list items that are 7 days old  I should be able to build a filtered view on the data    There is a hack to build a  Today  field that works  but doesn t filter properly    Does anyone have any good ideas

User · Answer

Warning about using TODAY  or any calcs in a column     If you set up a filter and have JUST  Today  it it you should be fine   But the moment you do something like  Today -1     the view will no longer show up when trying to pick it for alerts   Another microsoft wonder

User · Answer

Pass Today as value as mentioned below in  viewQuery property      web   Get-SPWeb  http   sitename   list    web Lists TryGetList  listtitle  write-host  Exporting     list Title   data from     web Title   site     viewTitle    Program Events   Title property  Add the column names from the ViewField property to a string collection  viewFields   New-Object System Collections Specialized StringCollection  viewFields Add  Event Date    gt   null  viewFields Add  Title    gt   null  Query property  viewQuery     lt Where gt  lt Geq gt  lt FieldRef Name  EventDate    gt  lt Value IncludeTimeValue  TRUE  Type  DateTime  gt  lt Today  gt  lt  Value gt  lt  Geq gt  lt  Where gt  lt OrderBy gt  lt FieldRef Name  EventDate  Ascending  True    gt  lt  OrderBy gt    RowLimit property  viewRowLimit   30  Paged property  viewPaged    true  DefaultView property  viewDefaultView    false  Create the view in the destination list  newview    list Views Add  viewTitle   viewFields   viewQuery   viewRowLimit   viewPaged   viewDefaultView  Write-Host   View       newview Title      created in list       list Title      on site      web Url   web Dispose

User · Answer

In the View  modify the current view or create a new view and make a filter change  select the radio button  Show items only when the following is true   in the below columns type  Created  and in the next dropdown select  is less than  and fill the next column  Today -7   The keyword  Today  denotes the current day for the calculation and this view will show as per your requirement

User · Answer

Have you tried this  create a Computed column  called  Expiry   with a formula that amounts to   Created    7 days   Then use the computed column in your View s filter  Let us know whether this worked or what problems this poses

User · Answer

If you want to filter only items that are less than 7 days old then you just use  Filter    Created is greater than or equal to  Today -7   Note - the screenshot is incorrect      Today  is fully supported in view filters in 2007 and onwards  just keep the spaces out   and you only need to muck around with calculated columns in 2003

[sharepoint] Filtering Sharepoint Lists on a "Now" or "Today"

Examples related to sharepoint