Welcome to uipath community
you can use filer datatable activity in this case @Blerton_Ismaili
The date would be of string type thats why it didn’t work and we must change it to datetime type buddy @Blerton_Ismaili
May i know the date sample you have and its format
Cheers
@Blerton_Ismaili once you get the table output as datatable.use assign activity below it and in the value place give as let say the output datatable is “outputDT” now in value place give as outputDT.select("Date<’ give date as your wish’ ").copy to datatable and assign this value to to variable.you will get output as datatable. hope this helps you.
this can help you @Blerton_Ismaili, for sure
Kindly revert for any queries or clarification
Cheers @Blerton_Ismaili
Can one of you guys have a look at my workflow… I tried it even with hardcoding the filtering date it does not work properly. Is there a possibility to make it flexible, so that it takes 1 week from today on?
ExtratByDate.xaml (14.7 KB)
@Blerton_Ismaili try to implement this in your xaml buddy
i tried with a sample of how to handle this
hope this would help you
Datefilter.zip (13.4 KB)
Kindly revert for any queries
Cheers
@Blerton_Ismaili i just now gone through your xaml file. the output which i get from your is code is the date which is greather than 27/04/2019.and it gives me correct output.
this is output which i get once it filtered.
Hey Buddy, Sorry for the late answer. I didn’t had time. No, unfortunately it didn’t work…
Yeah, that’s the same output I get. But the entries from month 5 are missing? there should aso be some entries from May… Do you understand what I mean?
Could someone help me?
Thanks guy! @Palaniyappan
The data in the excel comes from a webpage which is opened through my workflow. So basically there is no excel file. It is created in the end of the workflow. Have a look at my workflow.
ExtratByDate.xaml (16.0 KB)
@Palaniyappan I figured it out. Now it works. Now I tried doing the same workflow for another page. there it has an issue with the date do you know what the problem is here and how i can solve it.
This is the workflow…
ExtratByDate_SNB.xaml (14.4 KB)
It worked with the other “webpage” but not with this one. there is an issue with the date converting i thing.
kindly send with project.json file also
all together a zipped one
Cheers…this can be resolved