[Solved] Grouping shows time along with Date

[Aswin S]

I have a GridTemplateColumn in a RadGrid. It was a DateTime Column.

<telerik:GridTemplateColumn FilterListOptions="VaryByDataType" DataType="System.DateTime"
                    DataField="cr_task_dt" GroupByExpression="cr_task_dt Group By cr_task_dt" HeaderText="Next date to contact"
                    UniqueName="cr_task_dt" SortExpression="cr_task_dt">
                    <ItemTemplate>
                        <asp:Label runat="server" ID="lblTaskDate" Text='<%# Eval("cr_task_dt_str") %>'></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox CssClass="datepicker" ID="txtTaskDate" Text='<%# Eval("cr_task_dt") %>'
                            runat="server"></asp:TextBox>
                        <ajax:MaskedEditExtender ID="MaskedEditExtender4645" runat="server" TargetControlID="txtTaskDate"
                            Mask="99/99/9999" MessageValidatorTip="true" OnFocusCssClass="MaskedEditFocus"
                            OnInvalidCssClass="MaskedEditError" MaskType="Date" DisplayMoney="Left" AcceptNegative="Left"
                            CultureName="zh-SG" ErrorTooltipEnabled="True" />
                    </EditItemTemplate>
                </telerik:GridTemplateColumn>

The grid datasource was a linqdatasource. It works fine in all functionalities like sorting,filtering and grouping.
The only issue is it shows Time part in the grouping header as below,

"Next date to conact: 6/1/2010 12:00:00 AM"

"Next date to conact: 4/12/2010 12:00:00 AM"

I dont want the Time part (12:00:00 AM) to be displayed in the group header.  How to remove it?

Please help me sort it out. Thanks in advance.

Regards,

Aswin Suriya

[Schlurk]

I believe all you have to set is the DataFormat string as follows:

DataFormatString="{0:dd/MM/yyyy}"

This should take of displaying only the date and not the time.

[Aswin S]

Thanks for your reply,
But, I dont think GridTemplateColumn have a property called "DataFormatString"

[Princy]

Hi,

Try the code snippet below to format the group header item.

C#

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridGroupHeaderItem)
        {
            GridGroupHeaderItem item = (GridGroupHeaderItem)e.Item;
            DataRowView groupDataRow = (DataRowView)e.Item.DataItem;
            item.DataCell.Text = ((DateTime)groupDataRow["OrderDate"]).ToShortDateString();
            }
        }
    }

For more information on the same

http://www.telerik.com/help/aspnet-ajax/grdcustomizegridgroupheaderitem.html

Thanks,

Princy

[Aswin S]

Bingo! Thank you very much for the snippet Princy.
That worked like a charm.