Load Data Based on Date

[#1]

Hi!

I'm a Qlikview novice, looking to build my first (non-demo data) App.  I want to Load data from our "invoice table" only if the transaction date (txdate) is greater than 1/1/2010.  Looking at the example of this table in the select window, my txdate data appears to be in a M/D/YYY format.  I have looked at various where statement suggestions on the community pages and haven't seen anything that matches my query exactly.  I am looking for a statement, and also what lines to add the statement to (i.e. where do I put the statement?)  Please see PDF of script editor for additional detail.

Thanks in advance for any help!

[MK_QSL · Accepted solution]

Load  invnum,

       ....

....

Where txdate >= Date('1/1/2010');

SQL Select *

.....

only If your txdate is in M/D/YYY format..

[its_anandrjs]

What is your transaction(txdate) date format.

[its_anandrjs]

Load table like

If date format is different then use SET syntax and followed by load statements

SET DateFormat='M/D/YYYY';

Load

Statements

..

..

..

Where txdate >= '1/1/2010'

...

...

SQL SELECT *

FROM logongm.invoice

[#5]

Thanks so much for the quick help!