Filter Based on Date to get the current month

I have an excel file called Register with certain column:

Register Excel file sample:

ID|Start Time|Email|Name|Department
1| 3/1/21 12:02:47 | jasmine@gmail.com|Jasmine|Admin
2| 3/2/21 10:50:29 | tommygmail.com|Tommy|Engineering
3| 3/3/21 15:57:53| frederick@yahoo.com|Admin

I am testing my automation when the staff register on their application for using course material. Once register, their name will place on my Register file. I have another excel file called Main Master. The Main Master is my main Master File to contain descriptive data.

Main Master file sample:

ID|Start Time|Email|Name|Department
1| 3/1/19 12:02:47 | jasmine@gmail.com|Jasmine|Admin
2| 3/2/20 10:50:29 | tommygmail.com|Tommy|Engineering
3| 3/3/21 15:57:53| frederick@yahoo.com|Admin
3| 3/3/21 16:57:10| steward@yahoo.com|Admin
4| 3/4/2021 | mary@hotmail.com|Admin

For example, Mary just complete register on the 3/4/2021. Her name will be added on my excel file.

Results:
ID|Start Time|Email|Name|Department
1| 3/1/19 12:02:47 | jasmine@gmail.com|Jasmine|Admin
2| 2/3/21 15:57:53| frederick@yahoo.com|Admin
3| 3/2/20 10:50:29 | tommygmail.com|Tommy|Engineering
4| 3/4/2021 | mary@hotmail.com|Admin

I need to filter the datatable using Start Time column from the Register excel file to get only the current month. But it did not added to my Main Master for some reason.

Start Date

Hi @mosyahri

You can something like this

“Start time” >= Now.AddDays(-100)

“Start time”< Now

Try this

Regards

Nived N

Happy Automation