Pretty new to CAML queries, but trying to query a list based on Status = Completed and a date range.
It is throwing the following error "Unexpected Error: One or more field types are not installed properly. Go to the list settings page to delete these fields. Microsoft.SharePoint"
Status and Created are both system columns, so 99.9% sure I have the Field Names correct I have tested the query without the Date Range and it runs as expected, so I think my problem is somewhere in between
</leq> From what I have read, Created expects time to follow date. Query is below, any help would be greatly appreciated.
<Where> <And> <And> <Eq><FieldRef Name="Status" />Value Type="Choice">Completed</Value></Eq> </And> <Geq> <FieldRef Name="Created" /><Value IncludeTimeValue="TRUE" Type="DateTime">2013-07-02T00:00:01Z</Value> </Geq> <Leq> <FieldRef Name="Created" /><Value IncludeTimeValue="TRUE" Type="DateTime">2013-07-02T23:59:59Z</Value> </Leq> </And> </Where>