How to filter date based in excel

Hi all, using filter data table i need to filter 08/18/2020 date rows only. can you help to filter this values in excel. (using filter data table) @ImPratham45 @Pratik_WavhalBook1.xlsx (15.0 KB)

@Buvaneshwaran_R
find some starter help here:
FilterDate_MMMdyyyyyHHmmsstt.xaml (7.3 KB)
it was done on string base and as the date in datatable is in the form of 08/18/2020 … a LINQ with startsWith was used.

It should also work with the filter datatable activity but didn’t returned the expected result (This happens with this activity) so LINQ was selected for solution approach. If string base is not sharp enought then we could also shift to datetime.ParseExact method for implementing the filter statement.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.