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
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!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch