Apex Code Development You need to sign in to do that
Don't have an account?
Trigger that updates a date field when multiplied by a value in a number field
Can someone help me automating this requirement?
We have three fields => Start Date , Term_Duration__c , Termination Date . I want to update the Termination Date using a formula that calculates the date as Start date * Term_Duration__c , Terms is a number field that captures no. of months.
Any other alternative to do this will be greatly appreciated.
We have three fields => Start Date , Term_Duration__c , Termination Date . I want to update the Termination Date using a formula that calculates the date as Start date * Term_Duration__c , Terms is a number field that captures no. of months.
Any other alternative to do this will be greatly appreciated.
Formula field will be the best option for your purpose and i dont see why you will need process builder or workflow rule or any trigger for this kind of logic. Instead of multiplication between start date and term duration you will have to do addition of term duration to start date so it can give you exact termination date.
Thanks
Snehal
If it solved your problem then can you select the answer as best so others in community can use this knowledge?