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

1 ACCEPTED SOLUTION

Accepted Solutions
Thirteen Stars TRF
Thirteen 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
2 REPLIES
Thirteen Stars TRF
Thirteen 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!