I wish to calculate the remaining life of assets at a specific date based on the info below:..
ASSVALUE.ACQDATE..(Date/time stamp) - Acquisition Date
ASSVALUE.EXPLIFE..(Life in Years) - Expected Life in Years..(eg 30)
Currently I have a formula in an existing report (not developed by me) as below:
({ASSVALUE.ACQDATE}+ 365 *{ASSVALUE.EXPLIFE} - DateTime (1999,06,30))/365
"Assets that have reached the end of their Life prior to 30/06/1999"
While it appears to work I need to refine to select between two given dates... (Oracle db 8i I think)
If anyone is able to offer some immediate assistance it would be greatly appreciated.
TIA
Angus
ASSVALUE.ACQDATE..(Date/time stamp) - Acquisition Date
ASSVALUE.EXPLIFE..(Life in Years) - Expected Life in Years..(eg 30)
Currently I have a formula in an existing report (not developed by me) as below:
({ASSVALUE.ACQDATE}+ 365 *{ASSVALUE.EXPLIFE} - DateTime (1999,06,30))/365
"Assets that have reached the end of their Life prior to 30/06/1999"
While it appears to work I need to refine to select between two given dates... (Oracle db 8i I think)
If anyone is able to offer some immediate assistance it would be greatly appreciated.
TIA
Angus