topic Compare Dates in Talend Studio

Compare Dates

RA6 — Sat, 16 Nov 2024 00:19:42 GMT

Hello guys,

I need to compare the current_date with the dates below to check if it is more than 80 years or not.

Input :

1845-03-05 =>yes

1735-01-30

=>yes

2023-03-03

=>no

Any ideas how to do that,

Best regards,

Duke

Re: Compare Dates

gjeremy1617088143 — Fri, 02 Apr 2021 06:45:35 GMT

hi Duke, you can use Java.Time Library :

import java.time.LocalDate;

LocalDate start = LocalDate.of( 1845 , 3 , 5 ) ;

LocalDate stop = LocalDate.now();

long years = java.time.temporal.ChronoUnit.YEARS.between( start , stop );

if(years > 80)

{

here the result you want

}

Send me Love and Kudos

Re: Compare Dates

Anonymous — Tue, 06 Apr 2021 04:55:36 GMT

You can use the built-in function TalendDate.diffDate(Date date1, Date date2, String dateType) to get the difference between two dates, for more details about this function, go to Respository-->Code-->System-->TalendDate.

Regards

Shong

Re: Compare Dates

gjeremy1617088143 — Tue, 06 Apr 2021 06:41:31 GMT

Even Better if you use the TalendDate library