This is my first time using CAML Query.
I have a query builder which I can test with.
I'm trying to create a query that will look for a specific string of text in the "Title" column, and find the date "Created" less than equal to -180 days, and find "StatusPreSales" column equal to "Completed"
Title = Single Line Text Created = Date/Time StatusPreSales = Choice (DropDown)
<Query> <Where> <Eq> <FieldRef Name="Title"></FieldRef> <Value Type="Text">Schust Engineering</Value> </Eq> <Leq> <FieldRef Name="Created" /> <Value Type="DateTime"> <Today OffsetDays="-180" /> </Value> </Leq> <Eq> <FieldRef Name="StatusPreSales" /> <Value Type="Choice">Completed</Value> </Eq> </Where> </Query>
This is the code I have but It doesn't seem to be filtering the date correctly or picking up the value of StatusPreSales column.
Does anyone know what i can do to fix my query?