<?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 TalendDate.diffDateFloor in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/TalendDate-diffDateFloor/m-p/2326881#M96317</link>
    <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am giving the correct datatype as per the talend documentation, but somehow I am getting an error or the below:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;int B=TalendDate.diffDateFloor(TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:20:20"),TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:00:20"),"mm") ;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the error is:&lt;/P&gt;&lt;P&gt;Can't support the dateType: mm ,please try "yyyy" or "MM".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;it is taking only yyyy or MM..any idea what datatype to be given for minutes and seconds and hours?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 22 May 2019 20:58:42 GMT</pubDate>
    <dc:creator>param123</dc:creator>
    <dc:date>2019-05-22T20:58:42Z</dc:date>
    <item>
      <title>TalendDate.diffDateFloor</title>
      <link>https://community.qlik.com/t5/Talend-Studio/TalendDate-diffDateFloor/m-p/2326881#M96317</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am giving the correct datatype as per the talend documentation, but somehow I am getting an error or the below:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;int B=TalendDate.diffDateFloor(TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:20:20"),TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:00:20"),"mm") ;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;the error is:&lt;/P&gt;&lt;P&gt;Can't support the dateType: mm ,please try "yyyy" or "MM".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;it is taking only yyyy or MM..any idea what datatype to be given for minutes and seconds and hours?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 22 May 2019 20:58:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/TalendDate-diffDateFloor/m-p/2326881#M96317</guid>
      <dc:creator>param123</dc:creator>
      <dc:date>2019-05-22T20:58:42Z</dc:date>
    </item>
    <item>
      <title>Re: TalendDate.diffDateFloor</title>
      <link>https://community.qlik.com/t5/Talend-Studio/TalendDate-diffDateFloor/m-p/2326882#M96318</link>
      <description>&lt;P&gt;Strange, it is working with "ss", "mm" for&amp;nbsp;&lt;EM&gt;diffDate function, but not&amp;nbsp;diffDateFloor ...completely different from what is mentioned in documentation.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;anyways...I am marking this as solved.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;But if anyone has anything to comment on the above, Please feel free to do so. I would like to know what is the gap here.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 22 May 2019 21:23:29 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/TalendDate-diffDateFloor/m-p/2326882#M96318</guid>
      <dc:creator>param123</dc:creator>
      <dc:date>2019-05-22T21:23:29Z</dc:date>
    </item>
  </channel>
</rss>

