Re: Equipment Not Worked on.

["Wanko, Christopher G, CFCTR" <apollo@ATT.COM>]

> I have now been tasked to identify if any of these pieces of
> equipment had no work done during the user input time frame.  I have
looked
> at using not between in the date range but then I get all the work orders
> outside the date range.

I just can't get over the fact that you include equipment numbers in a
report!

Okay, okay, sorry for the critique.  To find equipment with no work done on
it between date ranges, in MAXIMO, you code this as your SQL.

select eqnum from equipment where eqnum not in
(select eqnum from workorder where reportdate between $x and $y)

-Chris