Filter date using Filter Wizard

Help
1

image

I need to filter the date where Date is older than ‘1st of December 2017’.

Thank you

2

Hello ,

Try using this!

Cdate(date_var) > Cdate(“1- Dec-2017”)

Thank you,
Anusha

3

Hi @rmfeliciano

If you have a one or two conditions it’s always simpler to use an assign activity :

FiltredDT = OldDT.Select("Column2 <= '1/1/2017'").CopyToDataTable()

note if you don’t use .CopyToDataTable() you will end up with an Array of Datarows.

Regards,
Reda

4

Should I put it in an assign or directly to the filter wizard?

5

Assign gives me an error “message”: “Assign : The source contains no DataRows.”,

6

Hi @rmfeliciano

Well I think you want your filtred dataTable to be transformed into an array of datarows, so the solution to this will be

dt_workItems = DT1.Select("Column2 &lt;= '1/1/2017'")