Finding greatest between two dates

[AAA999]

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]

TalendDate.compareDate

https://help.talend.com/reader/JdTBzKszzXoWvjpEJD3EBA/DrLxqWy9o3qakvD1e339AA

[AAA999]

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]

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