cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting collection by date BST issue

BenLyons1
Level 3
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

KasadorugePerer
Level 2
Hi Guy's Having the same issue.  Has anyone figured out a solution? Thanks in advance!

MaxMcConchie
Level 5
Hi,   I've noticed this too and I am interested in understanding why.   Thanks

Christopher
Level 5
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.