Maximo Open Forum

Looking for Where Clause script to show Work Orders that are due from the end of the current month backwards to include all work orders that are past due.

Queries on dates must be written differently depending on the database. Would you please tell us for which database the query should be and which field holds the "due date".

Try something like this (for SQL) -

Substitute the field you use for OVERDUE (TargStartDate is used here)….

and (TargStartDate <= convert(date,DATEADD(MM,DATEDIFF(MM,-1,getdate()),-1),101))