I have a dynamic CAML builder which I built to generate queries like the following:
<View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> <FieldRef Name="Modified" /> </ViewFields> <Query> <Where> <In> <FieldRef Name="Created" /> <Values> <Value Type="DateTime">2015-08-15T00:00:00Z</Value> <Value Type="DateTime">2014-08-15T00:00:00Z</Value> </Values> </In> </Where> </Query> </View>
I receive a "Value does not fall within the expected range" error. The query works when I change it to other field types like text, number, user, etc. It also works when I use this date format with an Eq element while querying the same field. Is there something I'm doing wrong here or is this element not supported for date fields?