Limit dates loaded

[cwhittington05]

Hi all, I have a database with data for 5 years and I need to only load data from 8/1/2008 forward.  Where and how in the script can I do this?  TIA!

[Frank_Hartmann]

You can use where clause:

SET DateFormat='DD/MM/YYYY';
tmp:
Load * Inline [
Date
8/1/2005
8/1/2008
8/1/2012
];

NoConcatenate

Load * Resident tmp Where Date>='8/1/2008'; DROP Table tmp;

[Wlad_Masi]

Hi @cwhittington05  have you seen this post Load Where?
We have lots of examples in our community that could match your need.
I hope this specific one helps.