topic Re: Between/AND check and pass the value in Talend Studio

Between/AND check and pass the value

Anonymous — Sat, 23 Jun 2018 09:50:15 GMT

I need to check the column DATE is between 2017-01-01 and 2017-12-31. If YES, then i should pass the value as 1 to the output field. How can i do this?

When i gave <= and >= in tMAP, its not accepting.

Re: Between/AND check and pass the value

TRF — Sat, 23 Jun 2018 10:39:32 GMT

Try this:

TalendDate.compareDate(row1.yourDateField, TalendDate.parseDate("yyyy-MM-dd", "2017-01-01"), "yyyy-mm-dd") >= 0 &&
TalendDate.compareDate(row1.yourDateField, TalendDate.parseDate("yyyy-MM-dd", "2017-12-31"), "yyyy-mm-dd") <= 0

Hope this helps.

Re: Between/AND check and pass the value

Anonymous — Sat, 23 Jun 2018 10:46:31 GMT

error. Input date field is string. Please suggest

Also, why its very complicated in talend just to compare two date.

Re: Between/AND check and pass the value

TRF — Sat, 23 Jun 2018 10:55:50 GMT

The example I gave you works fine for me.

Share your piece of code.

The date comparison is not "complicated" due to Talend but to Java.

Re: Between/AND check and pass the value

Anonymous — Sat, 23 Jun 2018 11:45:22 GMT

OK..

I just changed the field name from your code given and ran.

Re: Between/AND check and pass the value

TRF — Sun, 24 Jun 2018 11:21:26 GMT

EncounterActivityDate field seems to be a String but should be a Date.

Have a look to TalendDate.parseDate to convert from String to Date datatype.

Re: Between/AND check and pass the value

TRF — Mon, 25 Jun 2018 09:10:20 GMT

Does this help you?

If so, thank's to mark your case as solved (Kudos also accepted).