<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Unparseable date: &amp;quot;2020-07-25&amp;quot; in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278359#M53867</link>
    <description>&lt;P&gt;I am getting&amp;nbsp;java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2020-07-25"&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I am using a tMap to do the below&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="p1"&gt;context.Apttus__Contract_Start_Date__c != &lt;SPAN class="s1"&gt;&lt;STRONG&gt;null&lt;/STRONG&gt;&lt;/SPAN&gt; &amp;amp;&amp;amp;&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.compareDate(TalendDate.parseDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, context.Apttus__Contract_Start_Date__c.replaceAll(&lt;SPAN class="s2"&gt;"\""&lt;/SPAN&gt;, &lt;SPAN class="s2"&gt;""&lt;/SPAN&gt;)), TalendDate.getCurrentDate(), &lt;SPAN class="s2"&gt;"yyyy-MM-dd"&lt;/SPAN&gt;) == 1 ?&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.formatDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, TalendDate.addDate(TalendDate.parseDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, context.Apttus__Contract_Start_Date__c.replaceAll(&lt;SPAN class="s2"&gt;"\""&lt;/SPAN&gt;, &lt;SPAN class="s2"&gt;""&lt;/SPAN&gt;)),2,&lt;SPAN class="s2"&gt;"DD"&lt;/SPAN&gt;)) :&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.formatDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, TalendDate.addDate(TalendDate.getCurrentDate(),2,&lt;SPAN class="s2"&gt;"DD"&lt;/SPAN&gt;))&lt;/P&gt;</description>
    <pubDate>Wed, 27 May 2020 12:06:18 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2020-05-27T12:06:18Z</dc:date>
    <item>
      <title>Unparseable date: "2020-07-25"</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278359#M53867</link>
      <description>&lt;P&gt;I am getting&amp;nbsp;java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2020-07-25"&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I am using a tMap to do the below&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class="p1"&gt;context.Apttus__Contract_Start_Date__c != &lt;SPAN class="s1"&gt;&lt;STRONG&gt;null&lt;/STRONG&gt;&lt;/SPAN&gt; &amp;amp;&amp;amp;&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.compareDate(TalendDate.parseDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, context.Apttus__Contract_Start_Date__c.replaceAll(&lt;SPAN class="s2"&gt;"\""&lt;/SPAN&gt;, &lt;SPAN class="s2"&gt;""&lt;/SPAN&gt;)), TalendDate.getCurrentDate(), &lt;SPAN class="s2"&gt;"yyyy-MM-dd"&lt;/SPAN&gt;) == 1 ?&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.formatDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, TalendDate.addDate(TalendDate.parseDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, context.Apttus__Contract_Start_Date__c.replaceAll(&lt;SPAN class="s2"&gt;"\""&lt;/SPAN&gt;, &lt;SPAN class="s2"&gt;""&lt;/SPAN&gt;)),2,&lt;SPAN class="s2"&gt;"DD"&lt;/SPAN&gt;)) :&lt;/P&gt;
&lt;P class="p1"&gt;TalendDate.formatDateInUTC(&lt;SPAN class="s2"&gt;"yyyy-MM-dd 00:00:00"&lt;/SPAN&gt;, TalendDate.addDate(TalendDate.getCurrentDate(),2,&lt;SPAN class="s2"&gt;"DD"&lt;/SPAN&gt;))&lt;/P&gt;</description>
      <pubDate>Wed, 27 May 2020 12:06:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278359#M53867</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-05-27T12:06:18Z</dc:date>
    </item>
    <item>
      <title>Re: Unparseable date: "2020-07-25"</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278360#M53868</link>
      <description>&lt;P&gt;There exists value like "2020-07-25" without time, if you use date pattern &lt;SPAN&gt;"yyyy-MM-dd 00:00:00" to parse this value, it will throw this error. For testing, print the value of&amp;nbsp;context.Apttus__Contract_Start_Date__c.replaceAll(&lt;SPAN class="s2"&gt;"\""&lt;/SPAN&gt;,&amp;nbsp;&lt;SPAN class="s2"&gt;""&lt;/SPAN&gt;) to see what it is?&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Regards&lt;BR /&gt;Shong&lt;/P&gt;</description>
      <pubDate>Tue, 02 Jun 2020 11:41:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278360#M53868</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-06-02T11:41:38Z</dc:date>
    </item>
    <item>
      <title>Re: Unparseable date: "2020-07-25"</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278361#M53869</link>
      <description>Got help from here 
&lt;A href="https://community.qlik.com/s/feed/0D73p000004kkhqCAA#M121700" target="_blank"&gt;https://community.talend.com/t5/Design-and-Development/Unparseable-date-quot-2020-07-25-quot/m-p/220971#M121700&lt;/A&gt; and working fine now.. Thaks for the help</description>
      <pubDate>Wed, 03 Jun 2020 13:54:23 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unparseable-date-quot-2020-07-25-quot/m-p/2278361#M53869</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-06-03T13:54:23Z</dc:date>
    </item>
  </channel>
</rss>

