Format Date in a DataGrid

[Kenneth Keeley]

Hi,
I am reading in results from an SQL database one of the fields is a date
value. I wish to be able to display the date as only "dd/mm/yyyy" can some
body give me an example. Here is the code I am using at the moment.

<asp:BoundColum n HeaderText="Dat e" DataField="Inse rtDate"
SortExpression= "InsertDate " ItemStyle-Width="150" />

Thanks
Kenneth

[Kannan Meiappan]

Hi

In the item data bound event,
e.Item.Cells[6].Text =
Convert.ToDateT ime(e.Item.Cell s[6].Text).ToString ("dd-MM-yyyy");

instead of 6 change it your column number....

regards,
Kannan

"Kenneth Keeley" <ke*******@hotm ail.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi,
I am reading in results from an SQL database one of the fields is a date
value. I wish to be able to display the date as only "dd/mm/yyyy" can some
body give me an example. Here is the code I am using at the moment.

<asp:BoundColum n HeaderText="Dat e" DataField="Inse rtDate"
SortExpression= "InsertDate " ItemStyle-Width="150" />

Thanks
Kenneth

[Martin Dechev]

Hi,

Set the DataFormatStrin g property to whichever format you need. See the
BoundColumn.Dat aFormatString property topic for details:

http://msdn.microsoft.com/library/en...tringTopic.asp

See Formatting Overview (specifically the link to "Custom DateTime format
strings") to get more info on formatting:

http://msdn.microsoft.com/library/en...ngoverview.asp

Example:

<asp:BoundColum n HeaderText="Dat e" DataField="Inse rtDate"
DataFormatStrin g="{0:ddd, dd MMM yyyy, HH:mm}"
SortExpression= "InsertDate " ItemStyle-Width="150" />

for today, supposing the Thread.CurrentC ulture is "en-??" will display

Tue, 12 Oct 2004, 12:55

Hope this helps
Martin
"Kenneth Keeley" <ke*******@hotm ail.com> wrote in message
news:#x******** ******@TK2MSFTN GP11.phx.gbl...

Hi,
I am reading in results from an SQL database one of the fields is a date
value. I wish to be able to display the date as only "dd/mm/yyyy" can some
body give me an example. Here is the code I am using at the moment.

<asp:BoundColum n HeaderText="Dat e" DataField="Inse rtDate"
SortExpression= "InsertDate " ItemStyle-Width="150" />

Thanks
Kenneth