Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView SAP data pull query where caluse not working

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

1 Reply
Not applicable
Author

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