c# Linq select distinct date time days

Question

I have the following method which I planned to return a bunch of distinct date time objects. By distinct I means unique days (not including times).

The issue is, the the DateTime object have different times, and are therefore evaluating as unique even though they're the same day.

How can I have the query ignore the time part of the date and just evaulate the date for uniqueness?

Click to copy

    public List<DateTime> DistinctNoticeDates()
    {
        return (from notices in this.GetTable<Notice>()
                orderby notices.Notice_DatePlanned descending
                select notices.Notice_DatePlanned).Distinct().ToList();
    }

Thanks.

Answer 1

Try using the Date property to get just the date of DateTime structure:

Click to copy

public List<DateTime> DistinctNoticeDates()
{
    return (from notices in this.GetTable<Notice>()
            orderby notices.Notice_DatePlanned descending
            select notices.Notice_DatePlanned.Date)
            .Distinct()
            .ToList();
}