Filter date using select

[Marla_Ch]

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

[Latika10011740]

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.

Thanks
Latika

[supermanPunch]

@Marla_Ch

pDatatable.Select("PaymentDate ")

@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

[Marla_Ch]

@supermanPunch

ata

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

[supermanPunch]

@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