<?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>question Re: Date plus one day with update attribute in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350282#M235941</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Thank you for your support. The conversion to a date form type I had not in mind&lt;/P&gt;</description>
    <pubDate>Thu, 18 Aug 2022 06:39:06 GMT</pubDate>
    <dc:creator>MarioFRS</dc:creator>
    <dc:date>2022-08-18T06:39:06Z</dc:date>
    <item>
      <title>Date plus one day with update attribute</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350238#M235928</link>
      <description>&lt;P&gt;Hey everyone,&lt;/P&gt;&lt;P&gt;I want to make an API request for every single day in a period.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarioFRS_1-1660743746472.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/35186iADE2B8285B4FD064/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MarioFRS_1-1660743746472.png" alt="MarioFRS_1-1660743746472.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have defined a start date and an end date in the Generate Flow File Procesor&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarioFRS_2-1660743842652.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/35187i77987E2C1D3F9A89/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MarioFRS_2-1660743842652.png" alt="MarioFRS_2-1660743842652.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;the api structure is as follows&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;https://example.com/interfaces?session=${SessionId}&amp;amp;date_start=${since}&amp;amp;date_end=${since}&lt;/LI-CODE&gt;&lt;P&gt;and now I want to loop with route on attribute and update attribute to request all days in this time period.&lt;/P&gt;&lt;P&gt;now the question how can I, the attribute of the start date always increase by one day. with the following expression in the update attribute processore I get an empty field as result&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;${since:toNumber():plus(86400000):format('yyyy-MM-dd')}&lt;/LI-CODE&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarioFRS_3-1660744604543.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/35188i74B61964EE950429/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MarioFRS_3-1660744604543.png" alt="MarioFRS_3-1660744604543.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Result&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarioFRS_4-1660744717225.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/35190i251640C7188B575A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="MarioFRS_4-1660744717225.png" alt="MarioFRS_4-1660744717225.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Does anyone have an idea what adjusted we&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 17 Aug 2022 13:59:39 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350238#M235928</guid>
      <dc:creator>MarioFRS</dc:creator>
      <dc:date>2022-08-17T13:59:39Z</dc:date>
    </item>
    <item>
      <title>Re: Date plus one day with update attribute</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350241#M235929</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Try the following Expression:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;${since:toDate('yyyy-MM-dd'):toNumber():plus(86400000):format('yyyy-MM-dd')}&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If you find this helpful please accept solution. Thanks&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, 17 Aug 2022 14:35:30 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350241#M235929</guid>
      <dc:creator>SAMSAL</dc:creator>
      <dc:date>2022-08-17T14:35:30Z</dc:date>
    </item>
    <item>
      <title>Re: Date plus one day with update attribute</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350282#M235941</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Thank you for your support. The conversion to a date form type I had not in mind&lt;/P&gt;</description>
      <pubDate>Thu, 18 Aug 2022 06:39:06 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Date-plus-one-day-with-update-attribute/m-p/350282#M235941</guid>
      <dc:creator>MarioFRS</dc:creator>
      <dc:date>2022-08-18T06:39:06Z</dc:date>
    </item>
  </channel>
</rss>

