topic Re: Displaying data between 2 dates Introduced by User (URGENT PLEASE) in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 09:28:28 GMT

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.

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

TRF — Sun, 30 Jul 2017 18:34:42 GMT

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.

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

Anonymous — Sun, 30 Jul 2017 18:48:52 GMT

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 ?!

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

TRF — Sun, 30 Jul 2017 20:16:22 GMT

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).

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

Anonymous — Sun, 30 Jul 2017 20:39:17 GMT

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

Bluemoon — Sun, 30 Jul 2017 20:44:01 GMT

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

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

Anonymous — Sun, 30 Jul 2017 20:48:32 GMT

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

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

Bluemoon — Sun, 30 Jul 2017 20:50:30 GMT

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

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

Anonymous — Sun, 30 Jul 2017 20:55:51 GMT

Always the same problem

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

Bluemoon — Sun, 30 Jul 2017 21:16:19 GMT

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

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

TRF — Sun, 30 Jul 2017 21:52:42 GMT

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'.

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

Anonymous — Sun, 30 Jul 2017 22:24:57 GMT

String problem.

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

TRF — Mon, 31 Jul 2017 07:35:04 GMT

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

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

Anonymous — Mon, 31 Jul 2017 08:45:05 GMT

The fields are declared as Date format

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

TRF — Mon, 31 Jul 2017 09:54:01 GMT

Strange, it should work.

Share the content of the tMap Expression filter.

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

Anonymous — Mon, 31 Jul 2017 09:58:00 GMT