Filter data between two dates using LINQ

Question

How to filter data between two datetime. Here i am filtering the text file length in a directory..I need to filter text file between the selected date.

DateTime startDate = dateTimePicker1.Value;
DateTime endDate = dateTimePicker2.Value;
var queryList1Only = from i in di.GetFiles("*.txt", SearchOption.AllDirectories)  
                     select i.Length;

Any suggestion?

Answer 1

Use the Where clause:

DateTime startDate = dateTimePicker1.Value;
DateTime endDate = dateTimePicker2.Value;

var queryList1Only = from i in di.GetFiles("*.txt", SearchOption.AllDirectories) 
                     where i.GetCreationTime() > startDate && i.GetCreationTime() < endDate
                     select i.Length;

Instead of GetCreationTime you could use GetLastWriteTime or GetLastAccessTime.

I'd advise checking out a few examples using the where clause for a full understanding of how it all works here.

Answer 2

Well, how about a where clause?

var query = from i in di.GetFiles("*.txt", SearchOption.AllDirectories) 
            where (i.GetCreationTime() > startDate && i.GetCreationTime() < endDate)
            select i.Length;

Answer 3

from fi in new DirectoryInfo(@"c:\path").EnumerateFiles("*.txt")
where fi.CreationTime > startDate and fi.CreationTime < endDate)
select fi.FullName;