Discussion Board for collaboration on QlikView Scripting.
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:
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!
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.
And the date field is in datetime format
WHERE DOCDATE >= '04-01-2012 00:00:00'