Hi,

Hopefully someone can help me. I want to do a select statement on the =
events table, but for some reason when I do a select - it will only give =
me todays events. If I do a query with a begind of yesterday - I get =
yesterday's events.=20

for example:
tsm: BASSETT>select * from events where date(actual_start)=3D'02/19/2002'
ANR2034E SELECT: No match found using this criteria

Whereas I can do a q event * * begind=3D'02/19/2002'

as see this:

tsm: BASSETT>q event * * begind=3D'02/19/2002'
=20
Scheduled Start      Actual Start         Schedule Name Node Name     =
Status
-------------------- -------------------- ------------- ------------- =
---------
---------
02/19/02   00:00:00  02/19/02   00:02:57  GW1-INCR      GW1           =
02/19/02   00:00:00  02/19/02   00:02:57  GW1-INCR      GW1           =
Completed
02/19/02   01:00:00  02/19/02   01:15:15  TSI-INCR      TSI           =
Completed
02/19/02   01:00:00  02/19/02   01:01:01  BASSETT01_IN- BASSETT01     =
Completed
                                           CR
02/19/02   01:00:00  02/19/02   01:00:10  TESTAPP-INCR  TESTAPP       =
Completed
02/19/02   01:00:00  02/19/02   01:15:17  TRANSDB-INCR  TRANSDB       =
Completed
02/19/02   01:46:50  02/19/02   01:56:46  GISERVER_INCR GISERVER      =
Completed
02/19/02   02:00:00  02/19/02   02:08:17  TRANSIF_INCR  TRANSIF       =
Completed
02/19/02   02:00:00  02/19/02   02:06:27  STATGW-INCR   STATGW        =
Completed
02/19/02   03:00:00  02/19/02   03:07:11  UTILSRVR-INCR UTILSRVR      =
Completed
02/19/02   03:00:00  02/19/02   03:01:25  TSTTRANSDB-I- TSTTRANSDB    =
Completed
                                           NCR
02/19/02   03:20:00  02/19/02   03:21:58  MAILHUB-INCR  MAILHUB       =
Completed
02/19/02   04:00:00  02/19/02   04:03:11  ORSRVR-INCR   ORSRVR        =
Completed
02/19/02   04:00:00  02/19/02   04:13:54  BH1-INCR      BH1           =
Completed
02/19/02   04:00:00  02/19/02   04:12:21  TSTTRANSIF-I- TSTTRANSIF    =
Completed
                                           NCR
02/19/02   05:00:08  02/19/02   05:05:15  CWS01-INCR    CWS01         =
Completed
02/19/02   09:20:00  02/19/02   09:21:30  MAILHUB-INCR  MAILHUB       =
Failed

Any suggestions? I want to use select to do more processing - else I have =
to parse files.. not a problem - but a select would be easier.

Jane
%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Jane Bamberger
IS Department
Bassett Healthcare
607-547-4784