<?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: BAAAM tool export date format in Adobe Audience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/415972#M2501</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17412744"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is the BAAAM Date formula:&lt;FONT color="#993366"&gt; =((&lt;STRONG&gt;A2&lt;/STRONG&gt;/1000)/86400)+(DATEVALUE("1-1-1970")-DATEVALUE("1-1-1900"))&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;Make sure you replace the '&lt;STRONG&gt;&lt;FONT color="#993366"&gt;A2&lt;/FONT&gt;&lt;/STRONG&gt;' to reference the the date cell you are trying to change. Also make sure that the raw (reference) date column (in this example '&lt;FONT color="#993366"&gt;A2&lt;/FONT&gt;') is formatted as &lt;FONT color="#993366"&gt;general&lt;/FONT&gt;.&amp;nbsp;&lt;/P&gt;&lt;P&gt;The &lt;FONT color="#993366"&gt;new date colum&lt;/FONT&gt;n will need to be formatted as '&lt;STRONG&gt;&lt;FONT color="#993366"&gt;Custom&lt;/FONT&gt;&lt;/STRONG&gt;' and then you should make it: &lt;STRONG&gt;&lt;FONT color="#993366"&gt;m:dd:yyyy AM/PM&lt;/FONT&gt;&lt;/STRONG&gt;.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It can get a bit wonky sometimes so if anyone else has a better way please share.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Manny&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 14 Jul 2021 13:33:54 GMT</pubDate>
    <dc:creator>MannyVilla</dc:creator>
    <dc:date>2021-07-14T13:33:54Z</dc:date>
    <item>
      <title>BAAAM tool export date format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/413536#M2500</link>
      <description>&lt;P&gt;Hi, am trying to read the created and update date fields on the BAAAM export from AAM but the data which is available can't be transformed into any dates which Excel recognises, anyone know how to convert it? Thx&lt;/P&gt;</description>
      <pubDate>Wed, 23 Jun 2021 11:16:03 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/413536#M2500</guid>
      <dc:creator>richlodge5</dc:creator>
      <dc:date>2021-06-23T11:16:03Z</dc:date>
    </item>
    <item>
      <title>Re: BAAAM tool export date format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/415972#M2501</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17412744"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is the BAAAM Date formula:&lt;FONT color="#993366"&gt; =((&lt;STRONG&gt;A2&lt;/STRONG&gt;/1000)/86400)+(DATEVALUE("1-1-1970")-DATEVALUE("1-1-1900"))&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;Make sure you replace the '&lt;STRONG&gt;&lt;FONT color="#993366"&gt;A2&lt;/FONT&gt;&lt;/STRONG&gt;' to reference the the date cell you are trying to change. Also make sure that the raw (reference) date column (in this example '&lt;FONT color="#993366"&gt;A2&lt;/FONT&gt;') is formatted as &lt;FONT color="#993366"&gt;general&lt;/FONT&gt;.&amp;nbsp;&lt;/P&gt;&lt;P&gt;The &lt;FONT color="#993366"&gt;new date colum&lt;/FONT&gt;n will need to be formatted as '&lt;STRONG&gt;&lt;FONT color="#993366"&gt;Custom&lt;/FONT&gt;&lt;/STRONG&gt;' and then you should make it: &lt;STRONG&gt;&lt;FONT color="#993366"&gt;m:dd:yyyy AM/PM&lt;/FONT&gt;&lt;/STRONG&gt;.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It can get a bit wonky sometimes so if anyone else has a better way please share.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Manny&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 14 Jul 2021 13:33:54 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/415972#M2501</guid>
      <dc:creator>MannyVilla</dc:creator>
      <dc:date>2021-07-14T13:33:54Z</dc:date>
    </item>
    <item>
      <title>Re: BAAAM tool export date format</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/419591#M2730</link>
      <description>&lt;P&gt;I use the formula below (and then format that cell as a date)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;=A2/(86400000)+DATE(1970,1,1)&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;(where A2 contains the UNIX timestamp you are trying to convert)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 18 Aug 2021 11:21:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/baaam-tool-export-date-format/m-p/419591#M2730</guid>
      <dc:creator>r-seabrook</dc:creator>
      <dc:date>2021-08-18T11:21:47Z</dc:date>
    </item>
  </channel>
</rss>

