How to Filter Column based on first 5 dates

Hi,

Can you try as the following?

img20211111-f

arrDr =dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("DateColumn").ToString)>=new DateTime(Now.Year,Now.Month,1) AndAlso DateTime.Parse(r("DateColumn").ToString)<new DateTime(Now.Year,Now.Month,6)).ToArray

Note: arrDr is DataRow Array type.

Regards,

1 Like