In my custom list i have columns month and year. Both are string column. This is my query to get data
Query = @" <Where><And><Eq><FieldRef Name='Status' /><Value Type='Boolean'>1</Value></Eq>
<And><IsNotNull><FieldRef Name='month' /></IsNotNull>
<IsNotNull><FieldRef Name='
Year' /></IsNotNull>
</And>
</And>
</Where>
<OrderBy>
<FieldRef Name='Year' Ascending='False' />
</OrderBy>"
If i store data in list as
Month----------------Year
March----------------2016
April----------------2016
October----------------2016
Then the above query gives me below output
Month----------------Year
October----------------2016
March----------------2016
April----------------2016
It should be April before and then march. How can i solve this?