MaxTECH Maximo Technical User Group

we have field in Work Order which will dynamically update everyday with the value sysdate - Reportdate of work order. Could you please help me to how we can achieved this using formula for attributes. As sysdate changes everyday can we use them to calaculate work order age.

@Teja, to understand your request fully: you want to calculate the as-of days from the date the work order was created (report date). This is possible with a simple attribute formula. Just add a new attribute to the Work Order MBO (e.g. XXDAYSWOOPEN) and add a formula to this new created attribute. My question is (from a business / process point of view): until which status (e.g. COMP or CLOSE) do want to track the number of days a WO was open or in progress? I can imagine that you don't want calculations once a work order is completed or closed. In that case you can add some IF statements to the attribute formula. This, to avoid unnecessary calculation over all the work order (which can cause performance challenges.