Date format in gridview

Question

Possible Duplicate:
Format Date in Bind Statement inside a ListView

I have modified a master detail gridview example as per my requirement. It is working fine but date format in one of cell is displaying as "12/12/2012 12:00:00 AM". I just want to show only "12/12/2012". Please help, code is as below"

<asp:TemplateField HeaderText="Date of Failure" SortExpression="Failure_date" >
<EditItemTemplate>
<asp:TextBox ID="EditFailure_date" runat="server" Columns="20" MaxLength="50" Text='<%# Bind("Failure_date") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="Failure_dateRequiredFieldValidator" runat="server" ControlToValidate="EditFailure_date" Display="Dynamic"  ErrorMessage="Can not be blank" SetFocusOnError="True"></asp:RequiredFieldValidator>
 </EditItemTemplate>
 <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
 <HeaderStyle HorizontalAlign="Left" VerticalAlign="Top" />
 <ItemTemplate>
 <asp:Label ID="Failure_date" runat="server"  Text='<%# Bind("Failure_date") %>' ></asp:Label>
 </ItemTemplate>
 </asp:TemplateField>

score 5 · Accepted Answer · edited Oct 29 '12 at 02:33

5

This is the format that you should use:

<%# Bind("Failure_date", "{0:dd/MM/yyyy}") %>

edited Oct 29 '12 at 02:33

matt1125

3
3

answered Feb 02 '12 at 12:45

Richard

21,728
13
62
101

It is also working after placing " before {. Thank you Sir. – user1185088 Feb 02 '12 at 12:59

Emad Mokhtar · Answer 2 · 2014-01-30T16:21:57.930

2

You can do it by passing the format to the 2 Bind parameter.

Text='<%# Bind("Failure_date","{0:dd/MM/yyyy}") %>'

edited Jan 30 '14 at 16:21

answered Feb 02 '12 at 12:48

Emad Mokhtar

3,237
5
31
49

actually, it's not "YYYY", it is "yyyy". Thanks. – alansiqueira27 Jan 30 '14 at 12:57

Date format in gridview

2 Answers2