csegRollup hide expired items

May 31, 2008 - 1 min read

sharepoint
webparts
spsrollup

You can add a simple CAML query in order to hide the expired elements.

Use:

<Where>
  <Geq>
    <FieldRef Name=”Expires” />
    <Value Type=”DateTime”>
      <Today />
    </Value>
  </Geq>
</Where>

This query show only items which Expiration date is greater or equal than today date.

If you want use also the hour, you can use

<Where> 
  <Geq> 
    <FieldRef Name=”Expires” /> 
    <Value Type=”DateTime” IncludeTimeValue=”TRUE”> 
      <Today /> 
    </Value> 
  </Geq> 
</Where>