Formatting datetime field in gridview

Question

I have a field in a gridvie that displays the date in the following format

1/2/2012 3:45:13 AM

How can I format it so that it does ot show the seconds?

Thank you

   <telerik:GridBoundColumn 
    DataField="AdmissionDate" 
    HeaderText="Date" 
    SortExpression="AdmissionDate"
              HtmlEncode="False" />

Solution 1

Try this(short date and short time):

DataFormatString="{0:g}"

Although this is for BoundFields in an ASP.NET GridView, i assume(i have no experiences with Telerik controls) that it works also on a Telerik GridBoundColumn, because it also has this property.

• http://msdn.microsoft.com/en-us/library/system.globalization.datetimeformatinfo.aspx
• http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx

Solution 2

Something like this:

<Columns>
    <telerik:GridBoundColumn
        DataField="AdmissionDate"
        DataType="System.DateTime"
        HeaderText="AdmissionDate"
        SortExpression="OrderDate"
        DataFormatString="{0:MM/dd/yy hh:mm}"
        UniqueName="AdmissionDate">
    </telerik:GridBoundColumn>