Filter the View Data Web Part to Last 3 Days

Question

We have our own list, which has a column named "Date of connection" and should display the most recent elements of the list (relative to this column "Date of connection") in different places of the portal. the Data View web part is the best solution, but it's hard for me to find the right method and syntax for filtering by date.

I can create a parameter and filter the value for another column. I can filter for a specific date. I can’t understand how to say, "Show me all the elements of the list where the" Connection date "is in the range from [Today] and [Today] -3."

Is it possible? Does anyone know how to do this?

Thanks!

Answer 1

if you use caml, you can do it.

<Where>
  <Gt>
      <FieldRef Name="Created" Nullable="True" Type="DateTime"/>
      <Value Type="DateTime"><Today OffsetDays="-7"/></Value>
  </Gt>
</Where>  

Answer 2

thanks a bunch. between this answer and this blog we were able to figure it out.

http://blogs.msdn.com/sharepointdesigner/archive/2008/02/25/filtering-and-formatting-with-date-values.aspx#filter_list_on_today_offset