Filter Data table with current date

Help Activities
, ,
1

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

filter
filter1315×81 6.36 KB

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

Does anyone have the solution for this.

2

Hi @Gokul_Murali

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

Thanks

3

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.

4

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,

5

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

Regards
Gokul