Maddyhome Forums

I have a category which contains items with the original cost, purchase date and an annual rate of price change. I would like to create a calculation field which provides an approximate current value for the item. This would be great as it could be used to sum the current replacement value of the items for insurance purposes.

Purchase Date: 1-Sep-05
Cost: 1,300.00
Index: 3% p.a. (0.03)

I would like to be able to calculate:
Current Insured Value: (((Now - Purchase Date) / (Factor to get years old) * (Index)) + 1) * Cost

Currently you cannot add Date fields as attributes to a calculation if you want the result as a decimal / integer. Could this be added, or is there another way of doing this? It would be great for MyStuff2 to be able to capture and record the current insured value of items.

Yeah, this is a gap in what MyStuff2 supports. MyStuff2 will do "today() - Some Date" and give you a Term result. But there is no support for getting anything useful out of the Term value.

I need to add the ability to convert a Term result into a number where you specify if the number is the number of years, months, or days.

This is now on my TODO list.