topic Re: Finding greatest between two dates in Talend Studio

Finding greatest between two dates

AAA999 — Thu, 10 Jan 2019 18:29:25 GMT

Gurus,

Can anyone let me know what is the function in talend for comparing 2 dates and finding the greatest?

greatest (dt1, nvl(dt2,dt1)) as date.

Thanks

TRF — Thu, 10 Jan 2019 18:39:14 GMT

TalendDate.compareDate

AAA999 — Thu, 10 Jan 2019 18:43:07 GMT

Thanks! TRF for your quick reply. is there a function to handle it in tmap?I am using 2 tables for comparing the date columns?

TRF — Thu, 10 Jan 2019 20:57:27 GMT

Join both tables with a tMap then you can compare dates from main and lookup tables using the appropriate expression based on TalendDate routines.