Date filter in the load editor

[pascaldijkshoor]

Hello,

I want to add a date filter for loading data in the load editor. I have tried several where clauses but all didn't work.

The column name is SHIPMENT_DATE and the date format is for example: 1/23/2016 12:00:00 AM

I want to include only the data from 2017 and 2018, could someone help me with this?

Thank you in advance,

Pascal

[pascaldijkshoor]

I want to reduce the amount of rows, therefore i want to add the filter in the main script.

[pascaldijkshoor]

Unfortunately this did not work as well