Analytics and Data Mobile User Group! The mission of ADMUG is to connect individuals on Maximo Analytics in advancing insight on your Asset Management implementation. With a focus on knowledge sharing including successes and challenges.
Calculating date differences in QBR reports is a frequently used function.
The QBR Reporting guide details the syntax for this functionality - for Maximo's 3 supported database types - as shown below.
*Note: The sql functions must be added to the Expression Library before they can be used.
This guide can be downloaded here or from this url: https://www.ibm.com/support/pages/maximo-76-qbr-ad-hoc-reporting-and-ros-guide
And the information starts on page 26.