please help if it possible that CAML OffsetDays is not working in DvWP?
I use the following CAML within a DVWP:
<View><Query>
<Where><And>
<Lt>
<FieldRef Name="Date"/><Value Type="DateTime">{Param1}</Value>
</Lt>
<Gt>
<FieldRef Name="First_time><Value Type="DateTime">{Param1} OffsetDays="-6"</Value>
</Gt>
</And></Where>
<OrderBy>
<FieldRef Name="Category_Level" Ascending="TRUE"/>
<FieldRef Name="Rank" Ascending="FALSE"/>
</OrderBy>
</Query></View>
If I select Param1 = #1/2/2013#
, it returns all items where First_time >= #1/1/2013#
, but ignores First_time = #12/30/2012#
or First_time = #12/31/2012#
, accidentally?
I checked and it seems that even if I include the OffsetDays in CAML, the query ignores the tag in the DVWP.
Please help, how it could be resolved. Thanks!