This is a migrated thread and some comments may be shown as answers.

[Solved] Truncating the field values

2 Answers 117 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Phani Musale
Top achievements
Rank 1
Phani Musale asked on 17 Feb 2010, 10:39 AM
Hi,

Is there a way by which we can display a truncated value in a GridBoundColumn of Type DateTime. The value pulled from the database is "12/10/2010 03:10:07". This is is to be shown to the user as "12/10/2010" . 

Thanks

2 Answers, 1 is accepted

Sort by
0
Accepted
Shinu
Top achievements
Rank 2
answered on 17 Feb 2010, 11:56 AM
Hello Phani,

Set the DataFormatString for the GridBoundColumn as shown below.

aspx:
 
    <telerik:GridBoundColumn DataFormatString="{0:dd/mm/yyyy}" DataField="DOB" HeaderText="DOB" 
        SortExpression="DOB" UniqueName="DOB"
    </telerik:GridBoundColumn> 

-Shinu.
0
Phani Musale
Top achievements
Rank 1
answered on 17 Feb 2010, 11:58 AM
Ya, I figured that out. Thanks anyways.
Tags
Grid
Asked by
Phani Musale
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Phani Musale
Top achievements
Rank 1
Share this question
or