Sorting collection by date BST issue
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-03-18 02:08 PM
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 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 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?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-05-18 10:12 AM
Hi Guy's
Having the same issue. Has anyone figured out a solution?
Thanks in advance!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-05-18 04:41 AM
Hi,
I've noticed this too and I am interested in understanding why.
Thanks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-05-18 07:05 PM
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.
