C# OrderBy DateTime? without empty values taking priority

Asked Apr 20 '18 at 11:18

Active Apr 20 '18 at 11:18

Viewed 467 times

Currently I have the following LINQ extension to order my list by ascending order

var reportsAscending = report.OrderBy(x => x.ApprovalAuditDate).ToList();

But the problem I am having is that the list named reportsAscending has empty Approval Audit Dates at the start of the list rather than dates.

Is there a way to get the empty/null dates towards the end of the list?

The property is public DateTime? ApprovalAuditDate { get; set; }

For data type string I am using report.OrderBy(x => string.IsNullOrWhiteSpace(x.ApprovalStatus)).ThenBy(x => x.ApprovalStatus).ToList(); which works perfectly

asked Apr 20 '18 at 11:18

WKara

3

See duplicate. `.OrderByDescending(x => x.Date.HasValue).ThenBy(x => x.Date)`. – CodeCaster Apr 20 '18 at 11:20
3

`report.OrderBy(x => x.ApprovalAuditDate ?? DateTime.MaxValue)` – Fabio Apr 20 '18 at 11:20
Thank you very much +1 for converting it into Lambda – WKara Apr 20 '18 at 11:27
The expression from @Fabio worked – WKara Apr 20 '18 at 11:41

C# OrderBy DateTime? without empty values taking priority

0 Answers0