Hi
I have a grid of data that includes a datetime column. When I group by that column the group band shows "Date : 21/01/2008 00:00:00 (5 items)". I want it to show "Date : 21/01/2008 (5 items)"...i.e. without the time element. In the datagrid designer I have set the format of the cell to "dd/MM/yyyy" which has the desired effect on the cell content but not on the band header when grouped. What property can I change to have it display the way I want it.
Thanks and regards
Michael Bond
Hi Michael.
Do you have the latest hot fix? This was a bug that the GroupByRow was not picking up the formatting on the column. But it was fixed recently.
Well, I have (exactly) the same problem and I have the latest hot fix (as of last week). I have created a test project and I'm submitting an incident to Support today.
As a workaround, I insert the following in my InitializeGroupByRow handler:
e.Row.Description = Regex.Replace(e.Row.Description, @" 12:00:00 AM", "")
You would either have to internationalize this, or modify it for your locale.
Howardw39
Thanks for that workaround. That has worked for me.
Regards