Filtering Column by the Current Month

Help
1

Hi Everyone,

I am trying to filter the records by current month in Excel by using the Filter Data table activity on the column and the value I have given as Datetime.now.tostring(“MM”) .but Data table is empty.
Can any one please correct me regarding this.
Capture

Many thanks in Advance.

Regards
Vishnu

2

@winningvish,
can you elobarate more? and can you attach your excel file (if its not confidential)

3

Yes Naveen, need to get all the records of the month. By using the current system date.

4

can you attach the excel file?

5

Sure Naveen Please find the attachedAll Appointments 2-8-2019 10-23-59 AM.xlsx (31.0 KB)

6

Hi Naveen I got the Solution. Thank you for your reply.

Regards
Vishnu

7

@winningvish,
How did u achieve that? I was trying also…can you provide ur soln so that would be helpful .

8

Hi Naveen Sorry for the delay in replying.

Fisrt I have converted the date format for each row by using the assign activity
Convert.ToDateTime(row.item(“Start Time”)).tostring(“MMMM”)
After that I have filtered the Data Table by DateTime.Now.Tostring(“MMMM”)
Like this I got the desired result.

9

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