topic Date subtraction in talend in Talend Studio

Date subtraction in talend

RP1629548713 — Fri, 15 Nov 2024 23:18:27 GMT

Hi All,

I am trying to calculate age of a product.

For this i need to subtract the current date from initial date (creation _date) and result should be in months.

Can someone help me with the logic for this ? As diffdate is not working with the string data types .

Please suggest

gjeremy1617088143 — Mon, 17 Jan 2022 08:33:25 GMT

Hi, if your date are in String data type you can do something like this:

TalendDate.diffDate(TalendDate.parseDate("yyyy-MM-dd",(String of Date1)), TalendDate.parseDate("yyyy-MM-dd",(String of Date2)), "MM")

date pattern have to correspond to the date pattern of your String eg: "yyyy-MM-dd" for 2021-12-31

Send me love and kudos

RP1629548713 — Mon, 17 Jan 2022 09:01:05 GMT

I need to subtract it from the current date .

The current date - creation_date

gjeremy1617088143 — Mon, 17 Jan 2022 10:29:22 GMT

so replace TalendDate.parseDate("yyyy-MM-dd",(String of Date1)) by TalendDate.getCurrentDate()

RP1629548713 — Tue, 18 Jan 2022 12:05:09 GMT

Hi,

I tried implementing it ,but I get the following error :

Type mismatch: cannot convert from long to String

gjeremy1617088143 — Tue, 18 Jan 2022 13:29:36 GMT

Yes it's because diffDate return a Long and it seems you expect a String so :

String.valueOf(TalendDate.diffDate(TalendDate.getCurrentDate(), TalendDate.parseDate("yyyy-MM-dd",(String of Date2)), "MM"))