Create Saved Search to Display Difference in Days/Hours/Minutes from the Time Work Order is Created or in Pending Build Up to the Time it is Built

To create a Saved Search that displays the exact difference in Days, Hours and Minutes from the time a Work Order is created up to the time it is Built, perform the following:

1. Navigate to Lists > Search > Saved Searches > New.
2. Click Transactions.
3. On Criteria tab and Standard subtab, set the following:
• Type : is Work Order
• System Notes : Old Value : is Pending Build
• System Notes : New Value: is Built
• System Notes : Type : is Change
• Mainline : Yes
4. On Results tab and Columns subtab, set the following:
• Date
• Number
• Name
• Amount
• Date Created
• System Notes: Old Value
• System Notes: Date
• System Notes: New Value
• Formula (Text) > Formula : REGEXP_REPLACE(REGEXP_SUBSTR({systemnotes.date}-{datecreated},'[^.]+.'),'\.',' day(s)')
• Formula (Numeric) > Function : Number as Time > Formula : (REGEXP_SUBSTR({systemnotes.date}-{datecreated},'.[^.]+*$'))*24
5. Rename the Search as necessary.
6. Click Save.