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="&lt;View&gt;&lt;Query&gt;&lt;OrderBy&gt;&lt;FieldRef Name=&quot;Column3&quot; Ascending=&quot;TRUE&quot;/&gt;&lt;/OrderBy&gt;&lt;Where&gt;&lt;Geq&gt;&lt;FieldRef Name=&quot;Created&quot;/&gt;&lt;Value Type=&quot;Text&quot;&gt;&lt;Today OffsetDays=&quot;-8&quot;/&gt;&lt;/Value&gt;&lt;/Geq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;"