How to compare to list of date in C#?

Question

I have two list of date. I have to compare both list and find missing date. My first list looks like this:

My second list looks like this

I have to find the missing date between the two list :

I tried this

var anyOfthem = firstList.Except(secondList);

But it didn't work. Can anyone help me with this ?

.Except would return all values except those that are in `secondList`. So it's something completely different from what you want. — Steffen Winkler, Jul 31 '15 at 10:37
What do you mean by "didn´t work"? What did you get instead of the desired result? — MakePeaceGreatAgain, Jul 31 '15 at 10:40
@SteffenWinkler it's going to return the set difference so in this case a collection with a single item: 2015-07-24. Isn't it what you want Priya? Or do you want this to work both ways? — vc 74, Jul 31 '15 at 10:43
@vc, I want a collection with single item. (i.e) the one which is missing — Priya, Jul 31 '15 at 10:47
@vc74 well I wrote it wrong. It's not completely different but it's only half of the picture. — Steffen Winkler, Jul 31 '15 at 10:47
@Priya, then firstList.Except(secondList); should work. Are you getting any errors? — vc 74, Jul 31 '15 at 11:03

Fabjan · Accepted Answer · 2018-08-11T21:29:33.030

Well, you could use .Except() and .Union() methods :

        string[] array1 = 
        {
        "2015-07-21",
        "2015-07-22",
        "2015-07-23",
        "2015-07-24",
        "2015-07-25",
        "2015-07-26",            
        };

        string[] array2 = 
        {
        "2015-07-21",
        "2015-07-22",
        "2015-07-23",            
        "2015-07-25",
        "2015-07-26",
        "2015-07-27"
        };

        var result = array1.Except(array2).Union(array2.Except(array1));

        foreach (var item in result) 
        {
           Console.WriteLine(item);
        }

Output : "2015-07-24", "2015-07-27",

w.b · Answer 2 · 2015-07-31T10:57:14.707

string[] array1 = 
{
    "2015-07-21",
    "2015-07-22",
    "2015-07-23",
    "2015-07-24",
    "2015-07-25",
    "2015-07-26",            
};

string[] array2 = 
{
    "2015-07-21",
    "2015-07-22",
    "2015-07-23",            
    "2015-07-25",
    "2015-07-26",
    "2015-07-27"
};

var common = list1.Intersect(list2);
var anyOfThem = list1.Except(common).Concat(list2.Except(common));

foreach (var date in anyOfThem)
    Console.WriteLine(date);

// 2015-07-24
// 2015-07-27

score 0 · Answer 3 · edited Jul 31 '15 at 12:30

0

You have to check if one list contains the values from the other list :

var anyOfthem = firstList.Where(x => !secondList.Contains(x));

edited Jul 31 '15 at 12:30

thomasb

5,816
10
57
92

answered Jul 31 '15 at 10:37

MakePeaceGreatAgain

35,491
6
60
111

score 0 · Answer 4 · answered Jul 31 '15 at 10:41

0

hope this is exactly what your looking for:

var notamatch= firstList.Where(x => !anyOfthem.Any(y => y.yourseconddatename== x.yourfirstdatename));

answered Jul 31 '15 at 10:41

DeshDeep Singh

1,817
2
23
43

How to compare to list of date in C#?

4 Answers4