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

Help Studio
, ,
1

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
image

image

2

HI @tayyabimtiaz1

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

Regards
Gokul

3

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

4

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

5

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.

6

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

7

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

8

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

9

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

image

10

we can use the current date for this.

11

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

12

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