Filter Data table with current date

Hello guys,
i try to do a process related to filter data table.i run the process with a sample excel its working properly when i change the excel(BULK DATA) it only some header but it contain 53 headers. and data under the header also not reading.
Main.xaml (9.9 KB)
this is the code

This is some part of the excel(BULK DATA).

Does anyone have the solution for this.

Hi @Gokul_Murali

Can you tell us the exact issue you are facing ? and the output wanted.


Required Output:-

There is a column named "Approval date " we have to compare that date with the current date. if the date matches then read the entire row.(there are around 53 columns)

Issue:- I have used filter data table for this but the date is not filtering as per the condition. when i try read this excel and write it in a another excel the date format is changing.

Hi there.

This sounds like an Excel-related issue.

A workaround is to write it to an Excel file where all cells are formatted as Text.

I can’t help much more without a dummy version of your Excel file.

Warmest regards,

Hi @Gokul_Murali

How about this expression

Use Assign Activity

Dtfilter → Variable Type DataTable

DtFilter = DtreadFull.AsEnumerable.Where(Function(r) currentrow("Approval date").Tostring=DateTime.Now.ToString("MM-yyyy")).CopyToDataTable

DateTime.Now.ToString(“MM-yyyy”) → Date Format is based on the excel format