Displaying data between 2 dates Introduced by User (URGENT PLEASE)

[Anonymous]

Hello,

I am still new to the world of BI and especially Etl Talend, I want to make a display of different data that is in my table between 2 dates that I specify as condition, and that it does not display all the data for all The dates using tMap, i tried to use DateDiff here my condition: TalendDate.diffDate (row4.declarele, '2017-07-20') <= 0 && TalendDate.diffDate (row4.resolule, '2017-07 -25 ')> = 0
But I have this message "Invalid Character Constant".

I do not know what method to use in order to have this data in return.

It's URGENT please.

[TRF]

As said in my 1st answer

TalendDate.diffDate(row4.declarele, TalendDate.parseDate("yyyy-MM-dd", "2017-07-20")) <= 0 &&
TalendDate.diffDate(row4.resolule, TalendDate.parseDate("yyyy-MM-dd", "2017-07-25")) >= 0

Take care of "yyyy-MM-dd" instead of 'yyyy-MM-dd'.

[Anonymous]

String problem.

[TRF]

How are declared "declarele" and "resolule" fields?
It looks like they are String datatype but TalendDate.diffDate is expecting for 2 dates parameters.

[Anonymous]

The fields are declared as Date format

[TRF]

Strange, it should work.

Share the content of the tMap Expression filter.

[Anonymous]