If you are having error below in your admin page (VP-ASP 7.00) and you are using SQL SERVER database :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
/admin/shopauditsub.asp, line 46
if (ucase(xDatabaseType)="SQLSERVER") then
'6.50 - new config option to easily change date delimiter
if GetConfig("xsqlserverDateDelimiter") > "" then
newdate=yyyy & GetConfig("xsqlserverDateDelimiter") & mm & GetConfig("xsqlserverDateDelimiter") & dd
else
newdate=yyyy & "" & mm & "" & dd
end if
else
newdate=yyyy & "-" & mm & "-" & dd
end if
if (ucase(xDatabaseType)="SQLSERVER") then
'6.50 - new config option to easily change date delimiter
if GetConfig("xsqlserverDateDelimiter") > "" then
newdate=dd & GetConfig("xsqlserverDateDelimiter") & mm & GetConfig("xsqlserverDateDelimiter") & yyyy
else
newdate=dd & "" & mm & "" & yyyy
end if
else
newdate= dd& "-" & mm & "-" & yyyy
end if