Filter current date and current month entries from excel

Help Studio
1

Hi team,

I am trying to filter out current date and current month entries separately from excel sheet and store the entries in another excel, but it is not getting filtered. Can anyone please help?
The date entry are in the following format:
5/23/1974
12/23/1956
12/18/1992
9/27/1989
6/2/1981
2/9/1989
11/4/1984
4/16/1991
6/6/1987
12/1/1989
9/14/1990
9/29/1978
the date format cant be changed.

2

@Aishwarya_Bhargava Could you please provide a look of the output?

3

so i changed the date format:
so input is this:
image
and i want output to be the green highlighted rows

4

Use Set Range Color where you get the value as true and provide the row number and column name in the Range field.

5

these will not always be highlighted, i just highlighted the output rows just for an example

6

you want to filter on the basis of date and then highlight them?

7

I just want to filter them in two different ways

  1. Current Date (irrespective of the year) eg. for today i want to filter out all the dates of 15 September entry
  2. Current Month (irrespective of the year and date) eg. for today i want to filter out all the rows of september month entry
    and store the two filtered results in different data tables
8

@Aishwarya_Bhargava
1.Use excel application scope to read excel sheet
2.Use Read range excel activity to read respective data
3.Use for each row activity
4.Assign two variables as mentioned below

Inputdate=Convert.ToDateTime(row(1).ToString).Date.ToString(“MMM”).ToString
Note : row(1) contain dates .

SystemDate=System.DateTime.Now.Date.ToString(“MMM”)

Note: MMM will match the month of input date.

5.Use if condition to compare date
Inputdate=SystemDate

1 Like
11

thankyou it worked

12

@Aishwarya_Bhargava
Happy automation :slightly_smiling_face:

13

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