subtraction of dates

Five Stars

subtraction of dates

Good morning!

I request your support to know how the subtraction of two dates can be done and the result of these is only shown in days

example

Idstart datefinal datedays passed
125/06/201704/07/20179
201/02/201713/03/201740
313/11/201704/01/201852

 

the data that I need to know is: days passed

Help


Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: subtraction of dates

Hi,
Have a look at TalendDate.diffDate.

For example, in a tMap you have something like:

TalendDate.diffDate(row1.startDate, row1.finalDate, "DD")

TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: subtraction of dates

Hi,
Have a look at TalendDate.diffDate.

For example, in a tMap you have something like:

TalendDate.diffDate(row1.startDate, row1.finalDate, "DD")

TRF
Five Stars

Re: subtraction of dates


thank you very much, it really was a very useful solution
Regards!

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.