Load data based on a specific date

[qliky88]

Hi All, 

Just wondering what is the best way/ best practices to load data based on a specific date. I need to do this as my dataset is too large and I am experiencing memory errors. 

I want to look at everything after 2018. See my attempt below. 

Any help much appreciated as always 🙂 

LOAD RECORD_ID,
ID,
NAME,
STATUS,
PRODUCT_ID,
Date(Date#(DATETIME_CREATED,'DD/MMM/YYYY hh:mm:ss')) > Date(Date#('31/12/2018 12:00:00', 'DD/MMM/YYYY hh:mm:ss'));

[Steven_Haught · Accepted solution]

This can be done usually with a simple WHERE clause in your load statement. 

What is the current format of the Field, DATETIME_CREATED?

[qliky88]

Hi @Steven_Haught 

Looks like a simple where clause did the trick, thanks ! 🙂