> -----Original Message-----
> From: peter@... [mailto:peter@...]
> Sent: Miércoles 13 de Diciembre de 2000 17:58
>
> More Info from SQL monitor:
>
> SELECT ALL T_RECORD.*
> FROM T_RECORD
> WHERE (T_RDATE > = AND '11/30/2000' AND T_RDATE AND < = '11/30/2000
> 11:59:59 PM' AND T_RTYPE = 'I')
> ORDER BY T_RDATE ASC
> , T_DRAWERCODE ASC
>
> Where are these extra AND's coming from? Looks like a bug.

Besides that, unless IBO is doing something automatically, IB itself doesn't
accept AM/PM time, because it only works in 24-hours (also known as
military) time format.

C.