I might be way off track, but doesn't the between function require a full date and time specification? Try making that part of your sql statement look more like this:
I have limited experience, but I do know one thing that might help. SQL 2000 did not have schemas, but rather owners, so a fully qualified table name would...