Select "Date" in datatables


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)

Hi @abdel
please use this activity Filter Data Table


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

Hello abdel,

Here are the informations about the activity.

it needs 2018.2 version but what i have is 2018.1.3

Then you should pass by here :wink:

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 ="Date >= Now.addmonths(-1).tostring(“dd-MM-yyyy”)).Copytodatatable()

Hi @abdel,

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


Its giving syntax error

1 Like


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

please do let me know if you need any help