https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309269#M80501 Hi Wilson <BR /> <BR />I've also found another solution to that in this topic: <BR /> <BR />Comparing Dates in tMap(search this in google): <BR /> <BR />https://community.talend.com/t5/Design-and-Development/resolved-Comparing-Dates-in-tMap/m-p/103376 <BR /> <BR />I think you can find this helpful <BR />I hope you can resolve your problem <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR /> <BR /> <BR /> <BR />Locke Thu, 12 Nov 2015 00:42:32 GMT Anonymous 2015-11-12T00:42:32Z https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309267#M80499 <P align="left">i wanted to compare two dates in talend and pick the most future date take for example 20150302 and 20010323 then i pick 20150302 how can i write this in tmap?</P> Wed, 11 Nov 2015 12:55:18 GMT https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309267#M80499 Anonymous 2015-11-11T12:55:18Z https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309268#M80500 You can use the built-in function TalendDate.compareDate(parameters list) to compare two date, eg: <BR />TalendDate.compareDate(row1.date1, row1.date2)&gt;1? row1.date1:row1.date2 Wed, 11 Nov 2015 13:37:22 GMT https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309268#M80500 Anonymous 2015-11-11T13:37:22Z https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309269#M80501 Hi Wilson <BR /> <BR />I've also found another solution to that in this topic: <BR /> <BR />Comparing Dates in tMap(search this in google): <BR /> <BR />https://community.talend.com/t5/Design-and-Development/resolved-Comparing-Dates-in-tMap/m-p/103376 <BR /> <BR />I think you can find this helpful <BR />I hope you can resolve your problem <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR /> <BR /> <BR /> <BR />Locke Thu, 12 Nov 2015 00:42:32 GMT https://community.qlik.com/t5/Talend-Studio/Compare-two-dates-and-get-the-latest-one/m-p/2309269#M80501 Anonymous 2015-11-12T00:42:32Z