subtraction of dates

Highlighted
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
Fifteen Stars TRF
Fifteen 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
Fifteen Stars TRF
Fifteen 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!

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads