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]

 Hi,

TalendDate.diffDate is expecting to receive 2 dates so you need:

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

Hope this helps.

[Anonymous]

It does not always work, I think it is not the right function 'diffDate' that can show me the data between the 2 dates. 

Another solution please ?!

[TRF]

It does.
TalendDate.diffDate gives you the number of days between 2 dates.
Share your tMap (with correction) and tell us what's the result you got (or compilation error if any).

[Anonymous]

[Bluemoon]

please open the code in workspace and you will see a red mark on the right side. click and check the error line and share it with us

[Anonymous]

Yea, I use a different form of date but without any result 😕

[Bluemoon]

date format is different from the data which you have given yyyy-MM-dd

[Anonymous]

Always the same problem

[Bluemoon]

change 'dd-MM-yyyy' to 'yyyy-MM-dd' in designer -> open tMap editor ,
remember you can't change any code in code panel