subtraction of dates

[Anonymous]

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

Id	start date	final date	days passed
1	25/06/2017	04/07/2017	9
2	01/02/2017	13/03/2017	40
3	13/11/2017	04/01/2018	52

the data that I need to know is: days passed

Help

[TRF · Accepted solution]

Hi,
Have a look at TalendDate.diffDate.

For example, in a tMap you have something like:

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

[Anonymous]

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