Filter Data table on expiry date

[James_Yakupt (James)]

Hi Everyone

I’m using the filter data table for the expiry date. i have this scenario would like to capture the future date as shown below.

Date expiry
06/09/2025
05/09/2024
05/09/2023

Appreciate your assistance to guide me.

Thanks

[Yoichi]

Hi,

Can you share your input data and expected output?

Regards,

[James_Yakupt (James)]

Hi Yoichi

My expected data would like to have the 06/09/2026.

[Kanak_Lata_Singh]

Hi @James_Yakupt

Please provide more inputs for the scenario to make us understand better.

If you need to filter the datatable you can use Filter DataTable wizard , please refer below docs

Activities - Filter Data Table

How to use filter Datatable activity

Hello @varun_shinde1, Inside the Filter Datatable activity, you need to provide the Input DataTable and you need to provide the COlumn Name as Below. Also, you need to provide the value to filter as well. [image]

[Yoichi]

HI,

Can you share actual data as file, if possible? it’s no problem if dummy data.

Basically, the following settings will work

If data is stored as DateTime

If data is stored as String

Regards,

[batthula.p949]

HI @James_Yakupt

We can perform LINQ Query process to filter the data by converting the String format to DateTime format

Sample Input

1. Create a variable to hold all the possible formats of Date-Time in Array

arrayDateTimeFormat = {"dd/MM/yyyy", "MM/dd/yyyy"}

2. LINQ Query to filter the dates

dtTable = dtTable.AsEnumerable().Where(Function(x) DateTime.ParseExact(x.Item("DateTime").ToString, arrayDateTimeFormat, Nothing) >= DateTime.Now ).CopyToDataTable

3. Result will be store in dtTable

Thanks,
Purushotham

[James_Yakupt (James)]

Hi all

I try to screenshot. Appreciate it if you can assist me.

Thanks.