out-of-range smalldatetime value

Hej alle

Er ved at konvertere fra mysql til mssql og så får jeg denne fejl:
Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

Ved:
strSQL = "SELECT COUNT(online_now) as counter FROM CHAT_MEMBERS where last_online <> NULL and last_online between '" & Date() & " 00:00:00' AND '" & Date() & " 23:59:59'"

Sql:
SELECT COUNT(online_now) as counter FROM CHAT_MEMBERS where last_online <> NULL and last_online between '30-09-2004 00:00:00' AND '30-09-2004 23:59:59'

MSSQL-DB:
Last_online ligger i "smalldatetime"