locked
constructing CAML query RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I need to construct a CAML query which returns list items based on below condition

    item Created Date < Current Date - 1 Year, How to construct this

    can any one help.

    Thanks,

    reddy
    • Edited by Mike Walsh FIN Wednesday, December 14, 2011 5:11 PM Help needed in title
    Wednesday, October 5, 2011 11:15 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    try this:

     

       <Where>

          <Lt>

             <FieldRef Name='Created' />

             <Value Type='DateTime'>[Today-1Year(s)]</Value>

          </Lt>

       </Where>

     


    Wednesday, October 5, 2011 11:36 AM