Select "Date" in datatables

[abdel (Robot usa)]

Hello,

I’m extracting a string datatable, from windows application:

how to keep in the datatable only the values that the date are > = Date.ParseExact(Now.addmonths(-1).tostring(“dd-MM-yyyy”),“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture)

[reda (Reda_Marzouk)]

Hi @abdel
please use this activity Filter Data Table

[abdel (Robot usa)]

helloreda,

I can’t find this activity, in which package i is installed

[mustafa.altinbasak (Musalt)]

Hello abdel,

Here are the informations about the activity.
https://activities.uipath.com/lang-en/docs/filter-data-table

[abdel (Robot usa)]

it needs 2018.2 version but what i have is 2018.1.3

[mustafa.altinbasak (Musalt)]

Then you should pass by here

Mettre à jour Studio

[reda (Reda_Marzouk)]

Ohh it’s to bad the filter started from the 18.2
you have to do this the old fashion way

use this instead
yourDataTable = yourDataTable.select("Date >= Now.addmonths(-1).tostring(“dd-MM-yyyy”)).Copytodatatable()

[arivu96 (Arivazhagan A)]

Hi @abdel,

Try below code
dt=dt.select("Column1>=Now.addmonths(-1).tostring("dd-MM-yyyy")).CopyToDataTable()

Regards,
Arivu

[reddysrs (Swapna)]

Its giving syntax error

[rahatadi (Aditya Rahatekar)]

@reddysrs

use following expression

dt.select(“Convert([ColumnName] ,System.DateTime) > Convert('”+today.addmonths(-1)+“’ , System.DateTime)”)

please do let me know if you need any help

br,Aditya