Gridview Formating Question

[kcwallace]

I am using the following to generate a field in a gridview. Is there a way to format the data? specifically this is a returned date of 1/1/2007, but it displays the 1/1/2007 12:00. I need to drop the 12:00. THe backend is SQL Server 2005. Do I need to format it there?

 

<asp:TemplateField  HeaderText="SD" SortExpression="StartDate">
    <ItemTemplate>
               <asp:Label ID="Label15" runat="server" Text='<%# Bind("startdate") %>'></asp:Label>
    </ItemTemplate>
    <EditItemTemplate>
                <asp:TextBox ID="txtStartDate" runat="server" Text='<%# Bind("startdate") %>'></asp:TextBox>
     </EditItemTemplate>
     <FooterTemplate>
                 <asp:TextBox ID="txtStartDate" runat="server" Text=""></asp:TextBox>
      </FooterTemplate>
</asp:TemplateField>

[PlausiblyDamp]

You should be able to specify a valid format string as part of the binding expression i.e.

 

'<%# Bind("startdate") %>'
'replace with
'<%# Bind("startdate", "d") %>'

 

for a handy list of supported format codes try here

[kcwallace]

Thank you

 

<%# Bind("startdate", "{0:d}") %>

 

Worked perfectly