Filter date using select

Help Studio
1

how do i finish this off so i get all the dates in 2018
pDatatable.Select("PaymentDate ")

2

Hi @Marla_Ch

If you want to filter a data table column with payment date, you can also filter with Filter Data Table activity in uipath.
image
Thanks
Latika

3

@Marla_Ch Maybe this is what you needed :

pDatatable.Select(“PaymentDate Like ‘%2018%’”).CopyToDatatable

Check if it works or if it throws an Error, Specify the Error thrown

4

yeah throws an error : Cannot perform ‘Like’ operation on System.DateTime and System.String

5

@Marla_Ch Ok. You can Check with Filter Datatable Activity By Mentioning the “PaymentDate” as the Column Name and use Contains Operation and use “2018” as the Value.
Check if it Works.

If Filter Datatable operation doesn’t work then you can use the below query :

DT.AsEnumerable.Where(Function(x)x(“PaymentDate”).ToString.Contains(“2018”)).CopyToDataTable

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.