Format Date 1

[robertfah]

I've got a datagrid that shows a date (returned from SQL) and I don't want the time to show, just the date. can anyone tell me how I can do this?

<asp:BoundField DataField="RequestDate" SortExpression="RequestDate" HeaderText="Date">
  <ItemStyle VerticalAlign="top" Width="8%" />
</asp:BoundField>

 

[Meleagant]

I've done it on the server side like this:

        Dim field As WebControls.BoundField

        field = New WebControls.BoundField
        field.DataField = "MyDate"
        field.SortExpression = "MyDate"
        field.HeaderText = "My Date"
        [b]field.HtmlEncode = "false"
        field.DataFormatString = "{0:MM/dd/yy}"[/b]
        field.ItemStyle.HorizontalAlign = HorizontalAlign.Left
        GridView.Columns.Add(field)

* Sine scientia ars nihil est
* Respondeat superior

 

[robertfah]

Thanks a bunch....worked like a charm!