Need help to Filter dates older than a particular date

[Suhas_M (Suhas Mariyappa)]

How do i filter dates older than 01-05-2022. my date column is “Period From”

I tried filter data table activity but it is not working Hence, tried the select query and it looks like below

out_dt_fb(DataTable) = dt_fb.Select (“Period From< ‘01-05-2022’”).CopyToDataTable()

with this select query i am facing “Syntax error: Missing operand after ‘From’ operator.” exception.

Plz help in correcting the above query.

[supermanPunch (Arpan)]

@Suhas_M

out_dt_fb(DataTable) = dt_fb.Select (“Period From< ‘01-05-2022’”).CopyToDataTable()

Hi @Suhas_M ,

Firstly, Could you check with the modified expression below :

out_dt_fb(DataTable) = dt_fb.Select ("[Period From] < '01-05-2022'").CopyToDataTable()

Check if the above works and Gives out the proper output.

If the above does not work, then give a try on the below Expression :

inputDate = DateTime.ParseExact("01-05-2022","dd-MM-yyyy",System.Globalization.CultureInfo.InvariantCulture)

Here, inputDate is a variable of type DateTime.

Next, we use this Date variable for comparison like below and fetch the rows corresponding to older dates :

DT.AsEnumerable.Where(Function(x)CDate(x("Period From").ToString).Date<inputDate.Date).CopyToDatatable

More on DateTime and analysis :

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

Let us know if you are able to perform the appropriate filtration using this method.

[ppr (Peter)]

@Suhas_M

dt_fb.Select (“Period From< ‘01-05-2022’”).CopyToDataTable()

can you try
dt_fb.Select ("[Period From] < #01-05-2022#').CopyToDataTable()

we used

• [ ] to surround the col name as it has space
• # for a date compare

https://www.csharp-examples.net/dataview-rowfilter/

when an empty result can occur handle it as described here:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

When it is not working then share with us the datatable content by using the immediate panel

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

[RajKumar_DC (RajKumar Durai)]

Hi @Suhas_M

What about this

If(dtTest.Select(“[Period From] < #01-05-2022#”).Count>0,dtTest.Select(“[Period From] < #01-05-2022#”).CopyToDataTable,Nothing)

#01-05-2022#" = MM-dd-yyyy

Thanks,
Rajkumar

[Suhas_M (Suhas Mariyappa)]

Thanks, This Helped!!