How to sort items by a datetime field

Question

Article Publish Date is a field of type Datetime

List<Item> articles = GetArticles();

articles = articles.OrderByDescending(x => x.Fields[Constants.Templates.Article.Fields.ArticlePublishDate]).ToList();

The above line of code throws an error:

At least one object must implement IComparable.

How can this be resolved.

Answer 1

Mahendra's answer will work, but it is also possible to cast your field to a Sitecore.Data.Fields.DateField and retrieve the DateTime property, which will actually properly parse the field value and return a sortable DateTime value. I would implement it like this:

List<Item> articles = GetArticles();

articles = articles.OrderByDescending(x => ((Sitecore.Data.Fields.DateField)x.Fields[Constants.Templates.Article.Fields.ArticlePublishDate]).DateTime).ToList();

Answer 2

You are trying to sort by field not value, try below by removing Fields-

List<Item> articles = GetArticles();

articles = articles.OrderByDescending(x => x[Constants.Templates.Article.Fields.ArticlePublishDate]).ToList();