Date FORMAT in Tsaptableinput

[Anonymous]

Hi All,

I am using Talend 6.4.1 enterprise version and connecting to SAP 6.0 

I would like to add filter in tSAPtableInput component. 

It's date column, With the attached setup I get the date for the whole year, not just from Sep 1st.

I have tried various different date formats

DD-MM-YYYY

YYYY-MM-DD

If I compare something like this, I am not getting any rows. "FKDAT = '2019-09-01'". I checked in the backend it has data for this date.

Can you please help me with that?

Cheers!
Gatha

[Anonymous]

it looks like it uses, YYYYMMDD date format.