I am getting the following error when I try to format the way a date is going to be displayed.

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'DoDateTime'

I am using SQL Server 7 and IIS 4. The date field is:

Arrival_Date and datatype = smalldatetime

Has always worked in the past with UD and SQL 7 and UD with Access 2000.


Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

You could try:

dtDateVariable = Now() 'or a recordset date etc
response.write formatdatetime(dtDateVariable, vbShortDate)

********************
wheatNOTmeat