Is there a trick to formatting a Date when Grouping in Grid?

Jaymer · Post by **Jaymer** » Wed Oct 02, 2019 5:33 am

I'm grouping on a simple DATE field in SQL Server.
Haven't used Grouping much, and can't remember if I'm missing something.
Why is the date showing up like this?
Almost latest build, I'm on 2629 out of 2631

The default on the attribute is MM-dd-yy and I overrode it in the grid, to no avail.

customaware · Post by **customaware** » Wed Oct 02, 2019 8:09 am

I just had precisely the same issue.

Ended up creating an additional TEXT Attribute As_STRING(MyDate,'yyyy')

Jaymer · Post by **Jaymer** » Wed Oct 02, 2019 10:28 pm

i would think thats got to be a bug.

nowhere in Aware have I ever seen dates formatted as this:
Mon Sep 30 2019 00:00:00 GMT+0000 (Greenwich Mean Time)

I'll report it

Aware IM User Forums

Is there a trick to formatting a Date when Grouping in Grid?

Is there a trick to formatting a Date when Grouping in Grid?

Re: Is there a trick to formatting a Date when Grouping in G

Re: Is there a trick to formatting a Date when Grouping in G