How to select/Filter date between 180-190 days back?

I want to extract the data by filtering date’s between 180-190 days ago from calendar. The date from and date both must be between 180-190 days back from today. Screen shots are also available. There is an option for type in calendar like date,month,year

By default the date format is DD/MM/YYYY HH:MM:SS


HI @tayyabimtiaz1

You want to check something like whether the date are between 180-190 days back from today?


Hi @tayyabimtiaz1 ,

Are you able to set text into the field?
If so, you can simple perform the string → date conversion and pass it in.

Now.AddDays(-180).ToString("dd/MM/yyyy HH:mm:ss")

Now.AddDays(-190).ToString("dd/MM/yyyy HH:mm:ss")

Kind Regards,
Ashwin A.K

Yes, I need the data between 180-190 days back from today.

I need to filter/select the data between 180/190 days back from today. and i can type there and select from calendar as well.

Do you have any specific date to check that because we have more dates between th 180 -190 days back

Hi @tayyabimtiaz1 ,

If you can set text into the two respective fields, then could you try the above snippet of codes and see if that works out for you?

It reduces the number of steps, and makes your automation faster.

Kind Regards,
Ashwin A.K

Basically I need to run the process on weekly basis in which i can cover the data between these days. so that’s why i want the exact calculation

this select the date 10/03/2033 03:09:21 to 10/03/2035 04:08:21


we can use the current date for this.

I have tried this by using set text but it doesn’t work.

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