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!