Utility - Collection manipulation reducing dates

[JamesWilliams1]

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?

[John__Carter]

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.

[Denis__Dennehy]

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?

[JamesWilliams1]

Hi John I am in the UK

[John__Carter]

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?

[JamesWilliams1]

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.

[PriyankaTailor]

I am also having this issue - is there a resolution? We haven't yet migrated to V6 - would that resolve it?