Format Date in DataGrid

[crjunk]

In my table, I have a filed named Out_Date that has its DataType set to
STRING. When data for this field is displayed in the DataGrid, I need
it to be in the following format: MM/dd/yyyy

I have tried using the following, but it did not work.
<asp:BoundColumn DataField="Out_Date" HeaderText="OUT DATE"
DataFormatString="{0:MM/dd/yyyy}">

Any suggestions?

Thanks,
CR Junk

 

[Elton Wang]

You can cast data type in query:

Select Cast(Out_Date as Datetime) as Out_Date ...

HTH

 

[crjunk]

Thanks Elton! That did the trucjk.