How to filter excel data with activity filter with some date

hello :smiley: i want to filter info with the activity filter with some data that i decided for example if i want to have data after 01.01.2021 and have in the DataTable but the data table that i received is empty


if you had another solution let me know please

Hi,

Try like below. Not sure the datatype of your column in the datatable.

“Fetcha doc.” > cdate(“01.01.2021”)

If it didn’t work try below expression. Thanks.

“Fetcha doc.” > cdate(“01/01/2021”)

Hi,

Sometimes, it’s hard to handle FilterDataTable due to data type matter.
One of workarounds is to use LINQ as the following, FYI.

img20211130-2

dt = dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("Fecha doc.").ToString)>new DateTime(2021,1,1)).CopyToDataTable

Note: The above expression will throw exception If the result is empty.
So we might need to check number of result rows before using CopyToDataTable method.

Regards,