Restricting Date Ranges in Maximo Queries

[maximomatt]

You can use the 'sysdate' function in Maximo to help restrict date
ranges in Maximo.

The example below will proivede a list of all Work Orders that are
less than 30 past due:

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0
and istask = 0 and (schedstart between (sysdate - 30) and sysdate) and
actstart is null)

The 'sysdate' function returns the current system date. It also
supports date math so.. sysdate - 30 will return a date that is 30
days prior the current system date.


Here is another example that provides a list of all Work Orders that
are 30 to 60 days past due:

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0
and istask = 0 and (schedstart between sysdate-60 and sysdate-30) and
actstart is null