QlikView SAP data pull query where caluse not working

Wed, 20 Aug 2014 13:53:41 GMT

I have a simple query where i need to pull data with certain match to end date, however its not working.

Master:

Load

[KOSTL] ,

[ENDDA] ,

[PERNR] ,

SQL select ...... from .....

where ENDDA >= '12/31/9999'; // this statement does not seem to get right info. it gets all the data instead of 12/31/9999

Re: QlikView SAP data pull query where caluse not working

Wed, 20 Aug 2014 15:29:00 GMT

Might be a date format issue. Make sure ENDDA is in MM/DD/YYYY format.

SAP usually stores dates in YYYYMMDD. So try

ENDDA >= '99991231'

Thanks