sharepoint : retrieve records using caml query on DateTime valued columns

Question

hi all,

I have to retrieve all the items from a list based on the condition that are modified in the last 1 month. I am using the following Caml query but its not working.

<Query>
<Where>
<Geq>
<FieldRef Name="Modified" />
<Value Type="DateTime">[Today-30Day(s)]</Value>
</Geq>
</Where>
</Query>

Please help me regarding this issue.

Answer 1

Have you tried the OffsetDays attribute?

<Query>
    <Where>
        <Geq>
            <FieldRef Name="Modified" />
            <Value Type="DateTime">
                <Today OffsetDays="-30" />
            </Value>
        </Geq>
    </Where>
</Query>