SAP Date filter

[Anonymous]

Hi All,

I have connection setup and have to filter the data based on date column.

Format is YYYYMMDD when i am trying to filter it in Script either it is not filtering or throwing an error.

Any suggestion?

Thanks

Manish Madan

[robert_mika]

Could you post your data/ Errors/expression you are using?

I guess you need to use Date# or Date to bring the data into correct format.

[Anonymous]

Data format in SAP is YYYYMMDD i have updated the Qlikview format as well.

Now it is same as SAP.

while extracting the data from SAP i am adding conditiona as

STRTDATE>= 20150131;

then, it starts extraction but doing full load rather than loading data Feb onwards.

Thanks

Manish

[robert_mika]

Attached an extract.

Maybe what you got is a Text not Date and Qlikview can not fetch your data as you wish.

[Anonymous]

Try this

>= '20150131'

[Anonymous]

I use SAP tables daily using this filter logic

Let me know the table name if this doesn't work

[Anonymous]

Table name = TBTCO

[Anonymous]

column name STRTDATE

[Anonymous]

did you tried that date format?

[Anonymous]

yes, got the error message.