One of the top prizes for any Maximo users is having that "special" query that they know will absolutely find everything they are looking for. Recently I was asked to get a list of every PM in part of the a plant. The Maintenance Manager wanted the list to include …

A while back I wrote about how to use Javascript to calculate date functions in BIRT. In this post I will show different methods that can be used to automatically calculate dates so it can be scheduled as a rolling date report. The example I will use is for a …

One of the common tasks a report writer can be asked to do is sort or limit information based on certain dates or date ranges. They could use SQL functions like:

matusetrans.actualdate >= dateadd(day, -7, convert(varchar, getdate(), 101))

workorder.reportdate >= getdate() - 7
 

po.followupdate - getdate() >= 0

matusetrans.actualdate …

One of the things I try to re-enforce with Maximo users is striving to re-use their work, especially queries, as much as possible. A common task in Maximo is to find and sort information related to dates – order date, approval date, status date, etc. A common problem users come back …