Date FORMAT in Tsaptableinput

Anonymous — Wed, 25 Sep 2019 10:51:10 GMT

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

Re: Date FORMAT in Tsaptableinput

Anonymous — Wed, 25 Sep 2019 15:38:09 GMT

it looks like it uses, YYYYMMDD date format.