Filtering dates in Excel / CSV

Help Activities
, ,
1

Need help.

I have an excel file with several dates, I only need to data for the current date minus 1, meaning yesterday.

image

2

Hey

Try the following code

dt.AsEnumerable.Where(Function(x) CDate(x("yourcolumname").ToString.Trim).Day.Equals(Now.AddDays(-1))).CopyToDataTable

Regards

3

Hi,

What is x in Function(x) and Cdate(x) ?

4

an internal variable within the function that will allow us to call column names

5

Here is the sequence of UiPath code where do I place this command?

image
image527×774 20.7 KB

6

@Henson_Ibon you add a assign activity below filter activity and add the command in it. Replace ‘dt’ to ‘allstatusDT’ and ‘yourcolumnname’ to actual column name.

7

Hi,

Followed the solution but I get an error.

image
image1554×821 57.4 KB

8

Please check if the source data table has any data in it, else it will throw the above error.
In such case you can add a if else activity condition before the assign activity. In the condition add the above command, replace the “.CopyToDatatable” to “.ToList.Count > 0”