How to Use Select Method

[vickydas (vicky)]

So i have scraped Invoice from Acme Website and now i want to use Select(Filter) to get the invoice of data Greater than 7-1-2018 so how do i use select to only get the above given condition

Thanks in Advance

[PrankurJoshi]

Hi @vickydas

See these

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Filter Date in Date Table?

I have Data table name resultDt The datas are shown below [image] My requirement is to get the last 3 months count of the name. For example NewDate = today.Addmonths(-3) it will give 03-04-17.Now the NewDate is Compare to DataTable resultDt.After the NewDate I have 3 records So it Should return Count of Rows as “3”. Can some one help me to achieve this. Thanks in advance (Jothyprasanth M)

Thanks,
Prankur

[vickydas (vicky)]

Hello @PrankurJoshi first of all thank you for helping me below is a screenshot of my workflow please see what kind of error i am getting which is mentioned below

[PrankurJoshi]

Quotes are wrong in second condition.

[vickydas (vicky)]

Okay then what is the correct syntax.what is the correct placement of those quotes ?

[PrankurJoshi]

Try this

dt.Select("[InvoiceItem]='IT Support' AND Date > '2017-01-08'").CopyToDataTable

Or this

dt.AsEnumerable().Where(Function(r) r("InvoiceItem").Equals("IT Support") AND cDATE(r("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd")).CopyToDataTable

Or even this

(From p In dt.Select
Where "IT Support".Equals(p.Item("InvoiceItem")) And CDate(p.Item("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd")
Select p).CopyToDataTable

Thanks,
Prankur

[vickydas (vicky)]

@PrankurJoshi solved my problem thank you for your help