Need help to Filter dates older than a particular date

[ppr (Peter Preuss)]

@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