Column format for Date

[Kim]

I am trying to format a GridViewTextBoxColumn that contains a date using format string {0:MM/dd/yyyy}

However its ignoring the format and the 12:00 am is displaying behind the date.

How do i get a GridViewTextBoxColumn to format dates? 

Thanks.

Kim

[Nikolay]

Hello Kim,

Applying the desired FormatString would work if the value which the FormatString looks up is of type DateTime. However, when you place a DateTime value in a GridViewTextBoxColumn it is being converted to an ordinary string and FormatString has no effect on it. Therefore, if you need to format the value, it should be stored in a GridViewDataTimeColumn which will keep its DateTime type. Alternatively, if you for some reason need to use GridViewTextBoxColumn, you can manually format the shown text using the CellFormatting event:

void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.CellElement.Value != null)
    {
        int indexOfSpace = e.CellElement.Value.ToString().IndexOf(' ');
        e.CellElement.Text = e.CellElement.Value.ToString().Substring(0, indexOfSpace);
    }
}

I hope this helps. Regards,
Nikolay
Telerik