On 23.02.2001 11:44:55 mvandaele wrote:
> I tried a lot of statements similar to this one from visual basic on an access
> database:
> "select * from Times where" & strField & " between '" & CDate(FilterA) & "'
and
> '" & CDate(FilterB) & "'"
>
> =select * from Times where StartTime between '20/02/01' and '24/02/01
23:59:59'
Well, the date is wrong, I think. IIRC it must be '<Year>-<Month>-<Day>', so
'2001-02-20'. The time is correct, though.
> I always get the following error.
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
Never heard of that error message.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
