The solution will work to get all records older than current date. However in your excel file all the records having older dates hence you are getting all records in output.
Add some records of today’s date & future dates and verify.
Also if you want to filter it out for any other date rather than current date please substitute your required date value or variable in place of Now.ToString("dd-MM-yyyy)
No t the current Date, It should be Current Month. I have tested it But it getting all the records
DateFilter.zip (77.3 KB)
Hello @Marian_B , Please refer this Flow, You may got some idea.
To get date older than current month use the below
(As your data is formatted to Date format in excel file, it will work for your excel file)
It is getting all the records
Could you Check the below Expression :
Also you would need to follow the below Post to handle the Errors when you convert directly the Filtered Datarows into Datatable.
This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled.
Let’s have a look at the following filter data table scenario:
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:
There might be additional conditions that need to be added if there are multiple date formats/Empty values or change the
DateTime.ParseExact() to get the appropriate results.
Let us know if the expression doesn’t work, we can change the expression according to the results or the Error Message you receive.
Maybe the requirement is different than what it seems, From the Output we can see that the date 11/07/2022 is not present. We would require to know what is the logic you have used
Here is the workflow
OlderDate.xaml (7.5 KB)
Sample.xlsx (5.3 MB)
I need to Get the Older Dates than the current month in the Date column
Filter expression is not working
It seems that you have eliminated all the dates of the Previous Month as well as per the Output. So is the Logic actually to keep only the Dates lesser than (Current Month - 1) meaning dates lesser than July ?
Then maybe check the below modified Workflow if it reflects what you actually require. Let us know if this is not the required approach.
OlderDate.xaml (8.1 KB)
You will need to get all the older dates which is not in Current Month - Is that correct ?
Requirement is Eliminate all the date which are older
Need to keep Current Month and greater Month only
Current month or Greater Month
@Marian_B , The Sample Output you have provided doesn’t meet this requirement.
Needed only the Eliminate Month
@supermanPunch , So the Output looks like Only eliminated Month
Apologies for the wrong input file Here is the correct one
Sample.xlsx (5.3 MB)
Have you Checked if the above workflow that I have provided, gives you the required output for this input file ?
Let us know if it doesn’t provide the same Output.
Expression is working in the
Date column in have empty row. Bot throws an error @supermanPunch
Tried with this expression
DtreadFull.AsEnumerable.Where(Function(x)(CDate(x("Date").ToString).Year <= Now.Year) OrElse (CDate(x("Date").ToString).Month<(Now.Month)) OrElse isNothing(x("Date")) OrElse String.IsNullOrWhiteSpace(x("Date").ToString)).ToArray.copytodatatable
@Marian_B , What should be the output when there are empty values in date column, Do you want to Include it in the Output or remove it ?
Also, What is the Condition with
inc.per.CF column ?
Need to remove it from the output.
I have update the expression. By mistake i have placed it wrongly. Just ignore it
In that case, Could you Check the below modified expression :
DtreadFull.AsEnumerable.Where(Function(x)Not(String.IsNullOrWhiteSpace(x("Date").ToString)) AndAlso ((CDate(x("Date").ToString).Year <= Now.Year) AndAlso (CDate(x("Date").ToString).Month<(Now.Month)))).ToArray.copytodatatable
We would require to first Check whether date is empty or not and then convert the date value using
Let us know if you get any other errors.
Its working all the older Month and Current, But its not working for 2021