Problem with a report when grouped by "Due Date"

beachrandy

Hoping someone might be able to help with a report I created. I attempted to group rows in a report by "Due Date," but when I do that, some dates appear as normal dates (e.g. 09/02/23) while others appear in reverse, in different format, with an odd string of characters (e.g. 2023-05-30T16:59:59Z). Any ideas what is happening? The odd dates seem to be only coming from 3 or 4 sheets spread across 23 sheets from three different workspaces. Thanks

Andrée Starå

Hi @beachrandy

I hope you're well and safe!

Ensure that all the sheets, or at least those looking strange, are a date.

Was that the issue?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

beachrandy

Hi Andree,

Thanks for the reply. Yes, the Due Date column in the sheets that are causing me trouble are all configured as Date/Time column types.

Andrée Starå

@beachrandy

Happy to help!

Strange!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

beachrandy

Here's a screenshot. You can see the due date column appears normal on the far right; however, the due date used for the grouping is formatted oddly. The impact of this is that I have two separate groupings for the same due date that appear in different parts of the report. Thanks

beachrandy

oddly it's corrected itself and I'm not having the problem anymore... 🤦‍♂️

Andrée Starå

@beachrandy

Excellent!

Happy to help!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!