https://community.qlik.com/t5/Talend-Studio/Displaying-data-between-2-dates-URGENT-PLEASE/m-p/2358905#M123835 <P>Hello,</P> <P>I am still new to the world of BI and especially Etl Talend, I want to make a display of different data that is in my table between 2 dates that I specify as condition, and that it does not display all the data for all The dates using tMap, i tried to use DateDiff here my condition: TalendDate.diffDate (row4.declarele, '2017-07-20') &lt;= 0 &amp;&amp; TalendDate.diffDate (row4.resolule, '2017-07 -25 ')&gt; = 0<BR />But I have this message "Invalid Character Constant".</P> <P>I do not know what method to use in order to have this data in return.</P> <P>It's URGENT please.</P> Sun, 30 Jul 2017 14:14:02 GMT Anonymous 2017-07-30T14:14:02Z https://community.qlik.com/t5/Talend-Studio/Displaying-data-between-2-dates-URGENT-PLEASE/m-p/2358905#M123835 <P>Hello,</P> <P>I am still new to the world of BI and especially Etl Talend, I want to make a display of different data that is in my table between 2 dates that I specify as condition, and that it does not display all the data for all The dates using tMap, i tried to use DateDiff here my condition: TalendDate.diffDate (row4.declarele, '2017-07-20') &lt;= 0 &amp;&amp; TalendDate.diffDate (row4.resolule, '2017-07 -25 ')&gt; = 0<BR />But I have this message "Invalid Character Constant".</P> <P>I do not know what method to use in order to have this data in return.</P> <P>It's URGENT please.</P> Sun, 30 Jul 2017 14:14:02 GMT https://community.qlik.com/t5/Talend-Studio/Displaying-data-between-2-dates-URGENT-PLEASE/m-p/2358905#M123835 Anonymous 2017-07-30T14:14:02Z https://community.qlik.com/t5/Talend-Studio/Displaying-data-between-2-dates-URGENT-PLEASE/m-p/2358906#M123836 <P>See answer to your other post</P> Sun, 30 Jul 2017 18:35:43 GMT https://community.qlik.com/t5/Talend-Studio/Displaying-data-between-2-dates-URGENT-PLEASE/m-p/2358906#M123836 TRF 2017-07-30T18:35:43Z