MaxTECH Maximo Technical User Group

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
------------------------------

Hello Woodie, 
I have sent a message to some of the more technical gurus I work with to see what their answer might be.  I will post their reply once I receive it.  

regards, 
Stephen

------------------------------
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
------------------------------

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
------------------------------

------------------------------
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
------------------------------

------------------------------
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
------------------------------

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

  Here is a screenshot from the asset application...

------------------------------
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
------------------------------

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

  Here is a screenshot from the asset application...

------------------------------
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
------------------------------

Yep, that is definitely working better.
I am assuming the 0,0,0... equate to Year, Month, Hour, Minute, Second?
Is there a list that breaks these down?

------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940
------------------------------

Original Message:
Sent: Wed January 08, 2020 10:43 AM
From: Stephen Hume
Subject: Formula for Attribute

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

  Here is a screenshot from the asset application...

------------------------------
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
------------------------------

I have uploaded the file that I found on the internet which documents the formulas a bit. 
(MaximoFormula (2).pdf

------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779
------------------------------

Original Message:
Sent: Wed January 08, 2020 11:30 AM
From: Duane (Woodie) Wood
Subject: Formula for Attribute

Yep, that is definitely working better.
I am assuming the 0,0,0... equate to Year, Month, Hour, Minute, Second?
Is there a list that breaks these down?

------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940

Original Message:
Sent: Wed January 08, 2020 10:43 AM
From: Stephen Hume
Subject: Formula for Attribute

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

  Here is a screenshot from the asset application...

------------------------------
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
------------------------------

Thank you very much for the help and an excellent document on formulas.
I've added it to my repository.

------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940
------------------------------

Original Message:
Sent: Wed January 08, 2020 11:49 AM
From: Stephen Hume
Subject: Formula for Attribute

I have uploaded the file that I found on the internet which documents the formulas a bit. 
(MaximoFormula (2).pdf

------------------------------
Stephen Hume
Senior Maximo Consultant
BPD Zenith
403 464-5779

Original Message:
Sent: Wed January 08, 2020 11:30 AM
From: Duane (Woodie) Wood
Subject: Formula for Attribute

Yep, that is definitely working better.
I am assuming the 0,0,0... equate to Year, Month, Hour, Minute, Second?
Is there a list that breaks these down?

------------------------------
Duane (Woodie) Wood
CMMS Manager
EMCOR Government Services| Inc.
Arlington VA
571-403-8940

Original Message:
Sent: Wed January 08, 2020 10:43 AM
From: Stephen Hume
Subject: Formula for Attribute

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

  Here is a screenshot from the asset application...

------------------------------
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
------------------------------