Six Stars

Date calculation to add a year

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: Date calculation to add a year

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

Hope this helps.

TRF
4 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Date calculation to add a year

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

Hope this helps.

TRF
Highlighted
Twelve Stars TRF
Twelve Stars

Re: Date calculation to add a year

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

TRF
Six Stars

Re: Date calculation to add a year

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

Twelve Stars TRF
Twelve Stars

Re: Date calculation to add a year

Great!

TRF