I had a link list on a WSS v3 site and i wanted to show this list on other sites and subsites.
So i decided to plug to the datasource and extract the links using a DataView Webpart.
It all went well and good but i wanted another view that will show users latest links added a week ago for example .
So of course decided to use a filter using the
Field Name - Created
Comparison - Greater that or Equal to
Value - [CurrentDate]
But there was no way to change the CurrentDate from the Filter Criteria Menu because i need to do
CurrentDate - 5 (which means subract 5 days from the the CurrentDate.
Well i said to myself what left THE CODE
My first approach was use this caml query like so below but didn't work
<View><Query>
<OrderBy><FieldRef Name="Column3" Ascending="TRUE"/>
</OrderBy>
<Where>
<Geq>
<FieldRef Name="Modified"/>
<Value Type="Text">
<[Today]-4]/>
</Value>
</Geq>
</Where>
</Query>
</View>
Until i found out i could use an OffsetDays attribute like below :
<Value Type="DateTime"><Today OffsetDays="-8"/></Value>
Which means that 8 is subtracted from the date that the query filters on.
And that did the trick
<SharePoint:SPDataSource runat="server" SelectCommand="<View><Query><OrderBy><FieldRef Name="Column3" Ascending="TRUE"/></OrderBy><Where><Geq><FieldRef Name="Created"/><Value Type="Text"><Today OffsetDays="-8"/></Value></Geq></Where></Query></View>"