<?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 Re: datetimenotz / datetime types problem when aggregates are used in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/454124#M15290</link>
    <description>&lt;P&gt;May I know what data base you are using?&lt;/P&gt;&lt;P&gt;Have you tried converting both fields to datetime and check if the intersection is still working or not?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
    <pubDate>Tue, 31 May 2022 14:23:31 GMT</pubDate>
    <dc:creator>Deb_Tripathy</dc:creator>
    <dc:date>2022-05-31T14:23:31Z</dc:date>
    <item>
      <title>datetimenotz / datetime types problem when aggregates are used</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/453540#M15271</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a problem,&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We have database DATE fields defined as "datetimenotz" - however when during workflow we are using functions like max() then result is converted to "datetime"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Later during steps like intersection we are getting messages about datatypes incompatibility.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Is any way to solve that problem ?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;regards&lt;/P&gt;</description>
      <pubDate>Fri, 27 May 2022 04:53:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/453540#M15271</guid>
      <dc:creator>Klaster</dc:creator>
      <dc:date>2022-05-27T04:53:43Z</dc:date>
    </item>
    <item>
      <title>Re: datetimenotz / datetime types problem when aggregates are used</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/454124#M15290</link>
      <description>&lt;P&gt;May I know what data base you are using?&lt;/P&gt;&lt;P&gt;Have you tried converting both fields to datetime and check if the intersection is still working or not?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
      <pubDate>Tue, 31 May 2022 14:23:31 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/454124#M15290</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2022-05-31T14:23:31Z</dc:date>
    </item>
    <item>
      <title>Re: datetimenotz / datetime types problem when aggregates are used</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/454968#M15318</link>
      <description>&lt;P&gt;I'm using Oracle,&lt;/P&gt;&lt;P&gt;well, I prefer to convert just those values which are generated by Adobe because the rest of database uses&amp;nbsp;&lt;SPAN&gt;"datetimenotz"&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;regards&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 06 Jun 2022 20:09:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/datetimenotz-datetime-types-problem-when-aggregates-are-used/m-p/454968#M15318</guid>
      <dc:creator>Klaster</dc:creator>
      <dc:date>2022-06-06T20:09:58Z</dc:date>
    </item>
  </channel>
</rss>

