Woodie, I played around a bit with the formula and managed to get the date "creep" down significantly with the following formula
installdate+duration(0,0,expectedlife*365.25,0,0,0)
The result is an estimated end of life within 12 hours of accuracy... which for doing asset end of life estimates seems close.
This formula is putting the expectedlife*365.25 in the days position, which has a higher accuracy than the year position.
------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779
------------------------------
Original Message:
Sent: Wed January 08, 2020 07:08 AM
From: Duane (Woodie) Wood
Subject: Formula for Attribute
So, in short, this works but there seems to be a "creep" factor occurring that's knocking off hours.
Is there anything in those "0,0,0,0,0.." that could counter this?
------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940
Original Message:
Sent: Tue January 07, 2020 03:39 PM
From: Stephen Hume
Subject: Formula for Attribute
------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779
Original Message:
Sent: Tue January 07, 2020 03:38 PM
From: Stephen Hume
Subject: Formula for Attribute
------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779
Original Message:
Sent: Tue January 07, 2020 03:34 PM
From: Stephen Hume
Subject: Formula for Attribute
Hi Woodie, I managed to get a formula to calculate the ESTENDOFLIFE
Object Name: ASSET
Attribute Name: ESTENDOFLIFE
Formula Expression: installdate + duration(expectedlife,0,0,0,0,0,0)
I have a couple of screenshots of my test, but if you change either the install date or the expectedlife the estendoflife date is recalculated automatically.
Hope this works for you.
------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779
Original Message:
Sent: Tue January 07, 2020 06:35 AM
From: Duane (Woodie) Wood
Subject: Formula for Attribute
I am looking for a formula to add Life Expectancy (Integer "Years") to the INSTALLDATE in the Asset table.
I was looking at using the Add/Modify Formula for Attribute but I don't know who to write the Formula Expression since this would be adding an Integer to a Date. Can someone show me what the Expression would be?
I'm in a SQL environment
These are the two attributes
INSTALLDATE+EXPECTEDLIFE
------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940
------------------------------