DataFormatString="{0:dd/MM/yyyy}"
<asp:BoundField DataField="completiondate" HeaderText="CompletionDate" SortExpression="completiondate" DataFormatString="{0:dd/MM/yyyy}" />
<asp:boundfield datafield="ColumnName" dataformatstring="{0:yyyy-MM-dd}" htmlencode="false" xmlns:asp="#unknown" />
SELECT CAST(GETDATE() AS DATE) AS 'DateToday'
SELECT CONVERT(varchar(10), GETDATE, 111) AS 'DateToday'
<asp:boundfield datafield="Date" headertext="Date" xmlns:asp="#unknown"> SortExpression="date" DataFormatString="{0:dd/MM/yyyy}" /></asp:boundfield>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)