Retrieve List items using CAML Query

Question

• I have a list which contains 3 columns -ID, TicketState and EndDate

  ID        TicketState           EndDate(DD-MM-YYYY)
  
  1             Open            10/10/2012
  2            Closed           01/12/2012 
  3           Discard           05/05/2011
  4             Open            28/05/2013
  5           Discard           10/11/2012
  
  So, I want to retrieve those items whose TicketState is Either 
  Closed OR Discard, 
  AND
  EndDate < 1 year (from todays Date)
  

For that i have written following CAML Query but it is not working....

SPQuery myquery = new SPQuery();
    myquery.Query = "<Where>" +
                       "<And>" +
                           "<Or>" +
                              "<Eq><FieldRef Name='TicketState' /><Value Type='Choice'>Closed</Value></Eq>" +
                              "<Eq><FieldRef Name='TicketState' /><Value Type='Choice'>Discard</Value></Eq>" +      
                           "</Or>" +
                         "<Geq><FieldRef Name='End_x0020_Time' /><Value Type='DateTime' IncludeTimeValue='FALSE'><Today Offset='-365' /></Value></Geq>" +
                       "</And>" +
                    "</Where>";

EDIT:

Solved. Problem was with the internal name.

Answer 1

Solved...Problem was with the internal name....

Thank you..

Answer 2

You are using <Eq> with End_x0020_Time column, instead you should be using <Geq> or <Leq> as per your need..

Please have a look at:

Using Date offset in CAML query