Issue in filter data table to extract dates in the range of system date to (system date-28)

[arijit1213 (Arijit Chowdhury)]

hi,
i want to keep those date which are fall in the range of system date to (system date-28).
i try this using filter data table. but i can not get desired result. how can i do this?

my source file is in this way-

[Pratik_Wavhal]

Hi @arijit1213

Have a look to the below thread :-

How to filter date based in excel

@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 f…

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[arijit1213 (Arijit Chowdhury)]

hi,
it has done using linq query. but i want to do using filter data table.

[arijit1213 (Arijit Chowdhury)]

@lakshman please help me to solve this.

[arijit1213 (Arijit Chowdhury)]

date_filter.xlsx (8.5 KB)
this is my source file

[Sahil_Garg]

Hi arijit

Try this System.DateTime.Now.add(-28).ToString(“MM/dd/yyyy”) Store this expression in date time variable and then use filter table and put that variable in that .

Hope this will help u

Thanks
Sahil garg

[ppr (Peter Preuss)]

@arijit1213
have a look here:

the value of datacolumn is a DataType of string, but the compare should be done on dateTime base
surprisingly the statement dt1.Rows(0)(0).ToString < FilterDate works in the watch box but not in FilterTable
however it would do it on string base (Lexically order)

With a shift to the Select method the compare on dateTime base can easy be expressed
dt1.Select(“[post_date] < #”+FilterDate+“#”)
take notice of the surrounding #

find starter help here:
arijit1213.xaml (8.7 KB)

[arijit1213 (Arijit Chowdhury)]

hi @ppr
thanks for your reply.

i write the final result in an excel but i observed that result came by removing last 28 days dates. but my requirement is to get last 28 days dates.
Thank u.

[ppr (Peter Preuss)]

@arijit1213
as I was quick working on your case your filter expression from above was used:

so give a try on
dt1.Select("[post_date] >= … it should let pass the filter for all dates newer the now-28 days, Also dates
newer then today.

Otherwise reformulate your filter requirements more clear if the filter result is not matching your expectations

find some starter help here:
DTSelect_FilterDateRange.xaml (7.0 KB)

[arijit1213 (Arijit Chowdhury)]

hi @ppr
it work.only 1 change i had done in this part (it will be post date is grater than ). dt1.Select(“[post_date] > #”+FilterDate+“#”)
thank u