Hey guys I am trying to get a list of items with a "Created" date range. The problem is that upon executing the query it seems to be completely ignoring the 5000 row limit.
<View Scope='Recursive'> <Query> <Where> <And> <Geq> <FieldRef Name='Created' /><Value Type='DateTime'>2000-1-1</Value> </Geq> <Leq> <FieldRef Name='Created' /><Value Type='DateTime'>2001-1-1</Value> </Leq> </And> </Where> </Query> <RowLimit>5000</RowLimit> </View>
If I delete the tags inside the Query Tag it then limits the rows to 5000. This is pretty strange and I don't understand why this is happening with my CAML query.