How to limit data during first load?

[#1]

Hi,

I have this instance that from database, the data I will fetching is more than million of records, and in order to limit the data, I want only to load date that is equal or greater than April 1, 2012

So, this is the syntax:

Load ID,

        DOCDATE,

        ITEMNO;

SQL Select * from TABLE where DOCDATE >= '4/1/2012';

Is that possible? Say that I am connected to the database that is why I used SQL Select

Thanks for your help!

Regards,

Bill

[rwunderlich]

Yes, that is possible. The format of the date string depends on your DBMS. Check your reference documentation for "date literal" or tell us what DBMS you are using.

-Rob

[#3]

MSSQL

And the date field is in datetime format

[rwunderlich]

WHERE DOCDATE >= '04-01-2012 00:00:00'

-Rob