Date format and Filter data table

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

image

Hi @prititit

For this you can use Filter Datatable activity

Hope this would solve your query :slight_smile:
Mark as solution and like it.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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 :frowning:

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
image

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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
image

Hope this would solve your issue :slight_smile:
Mark as solution and like it.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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”)”

:slight_smile:

Hi @prititit

By the below way you can get your format :-

todaysDate.ToString(“MMMM”)+" “+todaysDate.ToString(“dd”)+”, "+todaysDate.ToString(“yyyy”)

image

And below will give you yesterday’s day in your format :-

todaysDate.ToString(“MMMM”)+" “+todaysDate.AddDays(-1).ToString(“dd”)+”, "+todaysDate.ToString(“yyyy”)

image

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 :slight_smile:
Mark as solution and like it.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

You’re a life saver, Pratik! Thank youuu!!!

Hi @prititit

Nothing like that.
You are always welcome :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.