Filter datatable on date

[Shirish]

Hi,

I have date in variable1=01/11/2019 and having excel columnname val = 01/11/2019. I have applied the filter on datatable using select method but it is throwing error. How to apply filter on excel col where excel col need to filtered with date which stored in variable1

[Rocki_Jan]

try creating a datetime variable and pass it in filter datatable activity instead of string value.

[PrankurJoshi]

Hi @Shirish

See these threads

Unable to filter datatable using date filter

I am unable to filter a datatable extracted from googlesheets. I need to filter the datatable using date columns. PFB the datatable format: [Sno,Resource Name,Contact #,Email ID,Local Computer Name,Domain Account,HDI name,HDI IP,Domain Expiry Date,VPN Expiry Date 1,XXXXXX,XXXXXXX,XXXXXXXX,XXXXXXXxx,XXXXXXXXX,XXXXXXX,1XXXXXXXx0,9/30/2019,9/30/2019] I need to create a filtered datatable that contains data with domainexpiry or vpn expiry that are about to expire in the next 15 days. I tried us…

Filter DataTable by Date doesn't work

Can someone have a look at my workflow and tell me why it doesn’t work. or even help me fix it? ExtratByDate_SNB.xaml (14.3 KB)

Filter DataTable by dates provided by user

Hello! I hope, someone can help me with this topic. I have tried some solutions from similar topics but nothing worked for me. I am trying to filter a data table, which contains one column with dates, based on the input from a user. Example: user needs to provide two dates (start and end), and the final table output, should contain only rows between these two dates. I already have converted each row of the datatable column using “Convert.ToDateTime(row(1).ToString).ToString(“dd.MM.yyyy”)”. U…

Thanks,
Prankur

[sarathi125 (Parthasarathi)]

@Shirish,

You can use Filter DataTable activity with a datetime variable created as per the attached xaml.
FilterExcelByDateCol.xaml (6.4 KB)