<?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 Change your values to text… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78717#M30713</link>
    <description>Change your values to text and add a control column and sort by that instead.
That would be the quick and dirty version at least.</description>
    <pubDate>Tue, 22 May 2018 18:05:00 GMT</pubDate>
    <dc:creator>Christopher</dc:creator>
    <dc:date>2018-05-22T18:05:00Z</dc:date>
    <item>
      <title>Sorting collection by date BST issue</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78714#M30710</link>
      <description>I have a collection of dates that I use the Collection Manipulation action "Sort Collection", there are no other columns in the collection and the data type is set&amp;nbsp;to Date (in both the input and output collections).

Dates after the switch to BST are being moved back 1 day during the action, so 27th March becomes the 26th. I'm guessing this is because the&amp;nbsp;Date Time is set to 27/03/2018 00:00 local time (even though the data isn't in this format), so when it sorts the data items it uses UTC meaning 27/03/2018 00:00 becomes 26/03/2018 23:00. Dates during GMT are not affected.

Any ideas how to fix/get around this issue?</description>
      <pubDate>Thu, 29 Mar 2018 13:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78714#M30710</guid>
      <dc:creator>BenLyons1</dc:creator>
      <dc:date>2018-03-29T13:08:00Z</dc:date>
    </item>
    <item>
      <title>Hi Guy's…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78715#M30711</link>
      <description>Hi Guy's
Having the same issue.&amp;nbsp; Has anyone figured out a solution?
Thanks in advance!</description>
      <pubDate>Mon, 14 May 2018 09:12:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78715#M30711</guid>
      <dc:creator>KasadorugePerer</dc:creator>
      <dc:date>2018-05-14T09:12:00Z</dc:date>
    </item>
    <item>
      <title>Hi,
 
I've noticed this too…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78716#M30712</link>
      <description>Hi,
&amp;nbsp;
I've noticed this too and I am interested in understanding why.
&amp;nbsp;
Thanks</description>
      <pubDate>Tue, 15 May 2018 03:41:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78716#M30712</guid>
      <dc:creator>MaxMcConchie</dc:creator>
      <dc:date>2018-05-15T03:41:00Z</dc:date>
    </item>
    <item>
      <title>Change your values to text…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78717#M30713</link>
      <description>Change your values to text and add a control column and sort by that instead.
That would be the quick and dirty version at least.</description>
      <pubDate>Tue, 22 May 2018 18:05:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Sorting-collection-by-date-BST-issue/m-p/78717#M30713</guid>
      <dc:creator>Christopher</dc:creator>
      <dc:date>2018-05-22T18:05:00Z</dc:date>
    </item>
  </channel>
</rss>

