https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297796#M70334 <P>Good morning!</P> <P>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</P> <P>example</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>Id</TD> <TD><SPAN>start date</SPAN></TD> <TD><SPAN>final date</SPAN></TD> <TD><STRONG>days passed</STRONG></TD> </TR> <TR> <TD>1</TD> <TD>25/06/2017</TD> <TD>04/07/2017</TD> <TD>9</TD> </TR> <TR> <TD>2</TD> <TD>01/02/2017</TD> <TD>13/03/2017</TD> <TD>40</TD> </TR> <TR> <TD>3</TD> <TD>13/11/2017</TD> <TD>04/01/2018</TD> <TD>52</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>the data that I need to know is: days passed</P> <P>Help</P> Thu, 04 Jan 2018 15:25:29 GMT Anonymous 2018-01-04T15:25:29Z https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297796#M70334 <P>Good morning!</P> <P>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</P> <P>example</P> <TABLE border="0" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD>Id</TD> <TD><SPAN>start date</SPAN></TD> <TD><SPAN>final date</SPAN></TD> <TD><STRONG>days passed</STRONG></TD> </TR> <TR> <TD>1</TD> <TD>25/06/2017</TD> <TD>04/07/2017</TD> <TD>9</TD> </TR> <TR> <TD>2</TD> <TD>01/02/2017</TD> <TD>13/03/2017</TD> <TD>40</TD> </TR> <TR> <TD>3</TD> <TD>13/11/2017</TD> <TD>04/01/2018</TD> <TD>52</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>the data that I need to know is: days passed</P> <P>Help</P> Thu, 04 Jan 2018 15:25:29 GMT https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297796#M70334 Anonymous 2018-01-04T15:25:29Z https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297797#M70335 <P>Hi,<BR />Have a look at TalendDate.diffDate.</P><P>For example, in a tMap you have something like:</P><PRE>TalendDate.diffDate(row1.startDate, row1.finalDate, "DD")</PRE> Thu, 04 Jan 2018 16:17:32 GMT https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297797#M70335 TRF 2018-01-04T16:17:32Z https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297798#M70336 <BR />thank you very much, it really was a very useful solution<BR />Regards! Thu, 04 Jan 2018 16:42:56 GMT https://community.qlik.com/t5/Talend-Studio/subtraction-of-dates/m-p/2297798#M70336 Anonymous 2018-01-04T16:42:56Z