This short ASP script will change the date in your database table from American format to a format which can be understood universaly.
OrderDate in the script refers to the column in the database table where the date is stored.
<%
'Change from American date format
If Day(DBOutput("OrderDate")) < 10 Then
'add a leading zero if date is single digit
Response.Write("0" & Day(DBOutput("OrderDate"))) & " "
Else
Response.Write (Day(DBOutput("OrderDate"))) & " "
End If
Response.Write(MonthName(month(DBOutput("OrderDate")), true)) & " "
Response.Write (Year(DBOutput("OrderDate")))
%>
