Group by "Created On" - Back to the Future Bug

[Bryan_TeamKickstart]

I have a view that is built to house newly created tasks that need to be reviewed.
I have them Grouped By: Created On.

The only issue is – it seems to be performing time travel (or maybe the “Group By” feature is using a different time zone than the Created On field)

See screenshot: I created a task just now – it has it in a group saying it was created… Tomorrow I created a task tomorrow already. I’m super on top of things, doing my work in the future

And, see the group for today – some were created today, some yesterday according to the field, but all today according to the group.

Any idea what may cause this or how to fix it?

And to confirm, here are my Group By settings:

[Stephen_Li]

@Bryan_TeamKickstart - tested and reproduced this. I’m thinking you’re right and it’s a time zone issue (since created_at is stored as a full ISO string unlike due_date and start_date). I’m wondering if the grouping specifically is just pulling the date from the ISO string (machine time zone-agnostic) and the field is using your machine time zone to display the local date of the ISO string. No idea why that would be the case, but that seems like the simplest explanation. Do the “time traveling” tasks all get created between 8pm and midnight ET?

Depending on volume, maybe sorting by creation date instead of grouping would work? That definitely does preserve the correct order, but you obviously lose the nice visual breaks of the grouping.

[Bryan_TeamKickstart]

@Stephen_Li - yes, the time traveling tasks are all created late at night in that time frame 8pm to midnight ET)-- checked just now.

Even though it’s helpful to understand the reason, this also seems like a design issue that should be fixed at some point.

@Vanessa_N could you let us know if the team is aware of this issue?

[lpb]

@Bryan_TeamKickstart, I ran into this very same issue next Tuesday and will post a Forum Leaders tips on it last week.

(Just kidding and trying to drive you crazy!)

Larry

[Bryan_TeamKickstart]

@lpb

[Vanessa_N]

Hi @Bryan_TeamKickstart and team, sorry for the delay! This definitely sounds like a timezone issue.

I haven’t seen this issue with “Group by” specifically, but I’ve seen similar cases with timezone affecting recurring tasks before. I’ve reported this to our Developers and will let you know once I have any updates

[Vanessa_N]

Hi everyone, our Developers have deployed a fix for this issue and things should be back to normal now. Let me know if you still see any problems.