Filter datatable on date

[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