topic Re: Date calculation to add a year in Talend Studio

Date calculation to add a year

Anonymous — Sat, 16 Nov 2024 09:18:34 GMT

Hello,

I have a date produced from a csv. In a tmap, I have two columns to populate with it. The first is the start date which is the exact same as the csv start_date (ex. 01-12,2017). I then need to use that date, but advance it by 365 days (1 year) to be the end date (same ex. 01-12-2018). I am not sure how to do this calculation.Appreciate any help or assistance.

Re: Date calculation to add a year

TRF — Mon, 11 Sep 2017 20:01:23 GMT

Hi,
You should found what you expect here http://dwetl.com/2015/04/28/talend-date-routine-function-with-examples/

Hope this helps.

Re: Date calculation to add a year

TRF — Tue, 12 Sep 2017 20:31:56 GMT

Did it help you?
If it did, feel free to mark the question as solved (Kudos also accepted).

Re: Date calculation to add a year

Anonymous — Tue, 12 Sep 2017 20:35:14 GMT

Thanks for the reminder. It was exactly what I needed and now bookmarked for future reference.

Re: Date calculation to add a year

TRF — Tue, 12 Sep 2017 20:48:08 GMT

Great!