How to extract data for last 7 consecutive days from an excel data table

[ppr (Peter Preuss)]

@faiqaqureshi90

28th is not available so it should miss all other dates like 26,25,and 24.

we can check woth a Linq and can return a true/false if all consecutive days were present or not in the datatable

Ideas:

(From x in Enumerable.Range(-7,7).select(Function (x) now.AddDays(x).date)
Let chk = dtDataVar.AsEnumerable.Any(Function (d) CDate(d("Update Date").toString).Date = x.Date)
Select b=chk).All(Function (x) x)

Depending on how the date are present in the datatable we mabye will adapt the datretime parsing with some little steps

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum