Linq to filter "Date" column in datatable

Help Studio
, ,
1

Hi team,

Need help to get Linq to filter column “Date” in datatable.

need datatable where “Date” column should have dates from today to next 6 days(ex : 06/15/2022 to 06/21/2022)

Help!!

1 Like
2

Hi @anishakotian400 ,

Check the below Query :

DT.AsEnumerable.Where(Function(x)CDate(x("Date").ToString).Date>=Now.Date andAlso CDate(x("Date").ToString).Date<=Now.AddDays(6).Date).CopyToDatatable
3

hi @anishakotian400

(From r In DT
Where DateTime.Parse(r(" Date").toString).Date.tostring("MM/dd/yyyy")> =Today.AddDays(0).Date.tostring("MM/dd/yyyy")  And
DateTime.Parse(r("Date").toString).Date.tostring("MM/dd/yyyy")  < Today.AddDays(8).Date.tostring("MM/dd/yyyy")
Select r).CopyToDataTable

hope this helps you

4

Tried given linq. Getting below errror
Error:
Assign: Conversion from string “” to type ‘Date’ is not valid.

5

there are some blanks, this is the reason most of the time when we do see this message

Have a look below for some analysis techniques and filter out empty values:

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

6

Hi @anishakotian400

did u try the linq i had given

7

Hi Arpan,
I wanted to extract missing dates from excel … For that can we apply linq query or any other approch

8

@Minal_U ,

We would request you to create a separate Topic, so that we do not mix things up with the Initial Requirement the post and it’s solution has to offer to other users who are looking for the same issue.

For your query on Missing Dates, Have an Initial look on the post below, but for further discussion do create a Separate Topic :

9

Have you considering using the “Select” method of the DataTable class? This will return an array of DataRow