thanks for your help. This totally worked!
Original Message:
Sent: 03-15-2024 01:55
From: Mark Johnson
Subject: calculate end date
American date format! Ahhhhh!
Ok not tested at all this below code but think you should be able to do this with some fairly simple mathematics and the Months() function.
Months Since AD = 1970 *12
Start Date Months = Months(Start Date)
End Date Total Months = Months Since AD + Start Date Months + Useful Life
End Date Year = Trunc(End Date Total Months / 12)
End Date Month = Mod(End Date Total Months / 12) + 1
End Date Day = Trim(Split(Start Date,2,"/"))
End Date = End Date Month & "/" & End Date Day & "/" & End Date Year
------------------------------
Mark Johnson
Delivery Manager - TBM Office
Origin Energy
+61 467 863 134
mark.johnson1@origin.com.au
Original Message:
Sent: 03-06-2024 03:23
From: Oliver Smith
Subject: calculate end date
I had such a painful experience trying to add dates together in Apptio but I did end up finding out how to do it. I didn't end up using it as I found a bit of a workaround.
You can convert a date column into months, then add that month value of Start Date to the Useful Life value, but to then get that month value back into a date, you need to convert it to seconds and then you can use =DateFormat(). To keep it super simple I'd do it all in separate columns like this:
Start Date in Months =Months(Start Date)
End Date in Months =Start Date in Months+Useful Life
End Date in Seconds =End Date in Months*30*24*60
End Date =DateFormat(End Date in Seconds,"MM/dd/yyyy")
The only drawback is that you have to multiply by days, then hours, then minutes to get to seconds so I just had to use 30 days for a month.
Hopefully this has helped and at least gives you an idea of what you could do.
If anyone can think of a nicer way to add months on to an existing date I'd love to hear it as it would still be useful for us to use as well.
Thanks,
Oli
Original Message:
Sent: 03-05-2024 15:17
From: Kyle Sellner
Subject: calculate end date
I need to calculate an end date for some assets. I have start date and useful life in months. Does Apptio have a function similar to EDate in excel?

#CostingStandard(CT-Foundation)