Javascript Date Functions in BIRT

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 …

Re-usable Date Queries in Maximo

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 …