Hi to all

Try to run a select command to get events when I run:

select date(Scheduled_start) as "Date", node_name , schedule_name , status
from events where date(Scheduled_start)=current date  and
domain_name='DOWINDOWS' group by scheduled_start ,node_name , status ,
schedule_name

Output:


      Date     NODE_NAME              SCHEDULE_NAME          STATUS
----------     ------------------     ------------------     ----------
2004-07-11     HIGHLEARN_WEB          SCHHIGHLEARN           Completed
2004-07-11     IBROWSE2               SCHED1                 Completed
2004-07-11     WEB2000_DB             SCHWEB2000_I_TDP       Missed
2004-07-11     HAIFADC01              SCHED5                 Completed
2004-07-11     HAIFADC02              SCHED6                 Completed
2004-07-11     EXCHANGE1              SCHEXCHANGEI_1         Completed
2004-07-11     HIGHLEARN2K            SCHHIGHLEARN_I_TDP     Completed

When I try to get 2  days before as:

select date(Scheduled_start) as "Date", node_name , schedule_name , status
from events where date(Scheduled_start)=current date - 2 days  and
domain_name='DOWINDOWS' group by scheduled_start ,node_name , status ,
schedule_name

Output:

ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
ANS8029E Macro processing terminated.

But when i run a query event for two days as:

q event dowindows * begind=today-2 endd=today endt=08:00

I got the correct list ........

Can anybody help to fix the select command for a correct result ......
T.I.A regards

Robert Ouzen
e-mail: rouzen AT univ.haifa.ac DOT il