https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49056#M4526 Hi John I am in the UK Wed, 26 Jul 2017 14:21:00 GMT JamesWilliams 2017-07-26T14:21:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49053#M4523 Hi, I am creating a process which utilises the Collection manipulation object to filter data which was sourced from an excel spreadsheet. Whenever I utilise the object it reduces the dates within the collection by 1 day each time. This even happens when I sort the dates in chronological order. The dates from the spreadsheet are formatted as dates and I have put them into the collection as dates. Has anybody experienced this before and has a solution? Wed, 26 Jul 2017 13:16:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49053#M4523 JamesWilliams 2017-07-26T13:16:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49054#M4524 Hi James - are you in the UK? Sounds like something to do with daylight saving time, where the hour difference takes you into the previous day. I'll do some experiments an get back to you. Wed, 26 Jul 2017 13:47:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49054#M4524 John__Carter 2017-07-26T13:47:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49055#M4525 Works for me (it must have caught both our interests JC!) - just filtered successfully on a text field and the date fields in those rows were unchanged. I agree it may be environmental in some way? Wed, 26 Jul 2017 14:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49055#M4525 Denis__Dennehy 2017-07-26T14:01:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49056#M4526 Hi John I am in the UK Wed, 26 Jul 2017 14:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49056#M4526 JamesWilliams 2017-07-26T14:21:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49057#M4527 Hi James - it is DST related and I think it's a bug. Can you mail me direct with your process + Excel and I'll come up with a work around? Wed, 26 Jul 2017 15:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49057#M4527 John__Carter 2017-07-26T15:11:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49058#M4528 Hi John No problem. I created a simplified process with a few filters and new excel data to check. Upon further investigation what it is doing is reducing each item that passes through the filter by 1 hour. Wed, 26 Jul 2017 15:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49058#M4528 JamesWilliams 2017-07-26T15:22:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49059#M4529 I am also having this issue - is there a resolution? We haven't yet migrated to V6 - would that resolve it? Wed, 17 Jan 2018 02:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Collection-manipulation-reducing-dates/m-p/49059#M4529 PriyankaTailor 2018-01-17T02:35:00Z