Hello,
I’m trying to get or filter the data by using the date and put it in another sheet.
I want to get all the data of May 20, 2020
Hello,
I’m trying to get or filter the data by using the date and put it in another sheet.
I want to get all the data of May 20, 2020
Hi @prititit
For this you can use Filter Datatable activity
Hope this would solve your query
Mark as solution and like it.
Happy Automation
Best Regards
Er Pratik Wavhal
Hi @prititit
Filter Datatable activity will solve your query.
If your still facing the issue refer this video.
Happy Automation!
Regards
Aditya
Hello Pratik -
I’ve tried and it works. If my date is in MM/dd/yyyy ex. 07/06/2020
But in this case, like “May 20, 2020” - it doesn’t work
Hi @prititit
So you are saying it is not identifying below date :-
“May 20, 2020”
??
Can the share the SS same as below for your activity
Happy Automation
Best Regards
Er Pratik Wavhal
now.AddDays(-1).ToString(“mmmm/dd/yyyy”)
Hi @prititit
You dont need to provide the format der
Like this you have to write. Below is the SS for the same
Hope this would solve your issue
Mark as solution and like it.
Happy Automation
Best Regards
Er Pratik Wavhal
Hi Pratik,
What if I have to get like yesterday’s date. Usually I use this if there is a data for yesterday’s date. That’s why im using the “now.AddDays(-1).ToString(“mmmm/dd/yyyy”)”
Hi @prititit
By the below way you can get your format :-
todaysDate.ToString(“MMMM”)+" “+todaysDate.ToString(“dd”)+”, "+todaysDate.ToString(“yyyy”)
And below will give you yesterday’s day in your format :-
todaysDate.ToString(“MMMM”)+" “+todaysDate.AddDays(-1).ToString(“dd”)+”, "+todaysDate.ToString(“yyyy”)
Below is the workflow for the same
Main.xaml (8.1 KB)
So as per this you can pass the variable by storing the date format you want or you can directly pass the format as you are doing already in the filter datatable activity
Hope this would solve your query
Mark as solution and like it.
Happy Automation
Best Regards
Er Pratik Wavhal
You’re a life saver, Pratik! Thank youuu!!!
Hi @prititit
Nothing like that.
You are always welcome
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.