How to get the last date of a column in Talend ?

[prabuj]

Dear Team, @Xiaodi Shi​  @Shicong Hong​ @Manohar B​  @Fred Trebuchet​  @Vladimir Apukov​ 

Could you help out with some sample example clearly ?

I have a requirement like this:

if (policy status is inactive)  

    so system will send the date of cancellation of the last active policy

else

   do not send

row1.policy_status.equals("INACTIVE") ? (system will send the date of cancellation of the last active policy )

how to get the date of cancellation of last active policy ?

Thanks in advance.

[Anonymous]

Hello,

It seems that you are referring to the last modified date for your column?

Here is Talend routine TalendDate with a method of compareDate(). 

Please have a look at this documentation about:

https://help.talend.com/r/en-US/8.0/open-studio-user-guide/comparing-dates

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

[prabuj]

@Xiaodi Shi​ Yes, am referring to the last modified date of a column? Could you help out with a example - I can't figure out with the link provided.

Thanks in advance.

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[jlolling_kloeckner]

If these data are in a database table thta would be easy to implement in SQL