Due Date Calcuation in Maximo Using Formula

In this blog, let us see how to calculate due date without any automation script or class files.

In Maximo, there is configuration that can be used for calculation purpose. The configuration is "Formula" present in the database configuration application.

Now let us see using the formula, how to calculte the Overdue Dates.

1. Create  a non-persistent attribute. In our example, we have created non-persistent attribute in the Work order object.

2. Now create a formula for that non-persistent attribute. From the Select More Action menu of the Database configuration application. Click on the Add/ Modify Formula for Attributes.

Sample Foumla:

(now() -SCHEDSTART)/ (60*60*24*1000)

To calculate the elapsed date from Schedule Start date.

3. Now display the attribute in the application designer. As this is a non-persistent and calculcated field, we need to make sure that field is read only.

Result: