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
Gokul001
(Gokul Balaji)
March 2, 2022, 5:32am
2
HI @tayyabimtiaz1
You want to check something like whether the date are between 180-190 days back from today?
Regards
Gokul
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.
Gokul001
(Gokul Balaji)
March 2, 2022, 5:36am
6
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.
system
(system)
Closed
March 9, 2022, 9:38am
12
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.