Apex Code Development You need to sign in to do that
Don't have an account?
autochic Advanced formula creation
I would like to create a formula field:
Contract Date x Term = Maturity Date
The contract date is as it says - in DATE format
The Term is in NUMBER format
The results should be in DATE format.
It seems like this might be possible with advanced formulas.
Would appreciate any suggestions.
Thanks!
Autochic,
Can you confirm that you want the ContractDate multiplied by the Term or only added?
If you want them added and the term is in months then a formula like this would give you a date that is close to accurate: ContractDate + (30 * Term). If you need it more accurate than that then you would need to pull the MONTH out of the ContractDate field and use a CASE function to calculate the accual number of days.