Change Format for Date

[Phoebe.]

Hi Good Day!

I hv a DataGrid which display info from SQLServer's database. The format for
date is YYYYMMDD.

I'd like to change this format to a more readable one which is DD/MM/YYYY.

How can I set it in the dataformatstring?

<Columns>
<asp:BoundColumn DataField="OrderDate" ReadOnly="True"
DataFormatString="??"></asp:BoundColumn>
</Columns>

Can someone help?
Thanks in advanced.

rgds,
Phoebe.

 

[Alvin Bruney [MVP]]

Try this .ToShortString().ToString("dd/MM/yyyy")