<?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 Hi Jonas,
 
Format the date… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Parsing-execution-date-of-processing-item-to-excel-error/m-p/58259#M12129</link>
    <description>Hi Jonas,
&amp;nbsp;
Format the date in in BP use dateformater in the same format as sheet, and then write in the excel sheet, this should work for you.
&amp;nbsp;
Regards
Ranjeet</description>
    <pubDate>Sat, 23 Jun 2018 20:37:00 GMT</pubDate>
    <dc:creator>RanjeetPatel1</dc:creator>
    <dc:date>2018-06-23T20:37:00Z</dc:date>
    <item>
      <title>Parsing execution date of processing item to excel error</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Parsing-execution-date-of-processing-item-to-excel-error/m-p/58258#M12128</link>
      <description>Hello,

&amp;nbsp;

For a process We have developed, we create a custom reporting sheet. In one column we write the date of execution (e.g. 17/06/2018) which we do by first formatting the excel cell to a date format.

For every item that has&amp;nbsp;been successfully finished, this does not pose a problem. However, for every case that went in error or Business exception, it sometimes reverses the day and month. (see file attached). e.g. i work an item on 7th June, it will write 07/06/2018 in the cell. However, if it would be an error case, it always writes 06/07/2018, which is very annoying.

Can anyone explain why this happens?</description>
      <pubDate>Fri, 22 Jun 2018 17:20:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Parsing-execution-date-of-processing-item-to-excel-error/m-p/58258#M12128</guid>
      <dc:creator>JonasBertels</dc:creator>
      <dc:date>2018-06-22T17:20:00Z</dc:date>
    </item>
    <item>
      <title>Hi Jonas,
 
Format the date…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Parsing-execution-date-of-processing-item-to-excel-error/m-p/58259#M12129</link>
      <description>Hi Jonas,
&amp;nbsp;
Format the date in in BP use dateformater in the same format as sheet, and then write in the excel sheet, this should work for you.
&amp;nbsp;
Regards
Ranjeet</description>
      <pubDate>Sat, 23 Jun 2018 20:37:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Parsing-execution-date-of-processing-item-to-excel-error/m-p/58259#M12129</guid>
      <dc:creator>RanjeetPatel1</dc:creator>
      <dc:date>2018-06-23T20:37:00Z</dc:date>
    </item>
  </channel>
</rss>

