Apex Code Development You need to sign in to do that
Don't have an account?
Date Field Formula based on Additional Months
Hello All,
I have 2 date fields and a number field.
Date Fields: Start Date, End Date
Number Field: Subscription Term
I would like to populate the End date based on the Subscription Term. Example: Start Date = 2/13/2017, Subscription Term 13 months, End Date = 3/13/2018.
Not sure how to start writting a formula for this.
Thanks,
Hieu
I have 2 date fields and a number field.
Date Fields: Start Date, End Date
Number Field: Subscription Term
I would like to populate the End date based on the Subscription Term. Example: Start Date = 2/13/2017, Subscription Term 13 months, End Date = 3/13/2018.
Not sure how to start writting a formula for this.
Thanks,
Hieu
Texted base formula:
DATE( Year([start date])+floor((MONTH([start date]) + [# of months] - 1) / 12) ,
mod(MONTH([start date]) + [# of months] -1, 12) + 1 ,
day([start date])
) - 1
Check out the link below which I got from success community.
https://success.salesforce.com/answers?id=90630000000gymAAAQ
Hope it helps you. If it helps, mark this answer as solved.
Regards,
Roshni