You need to sign in to do that
Don't have an account?
Stephen Glaros 7
Formula for adding custom number field (as days) to date formula?
Hi Community,
I thought this would be an easy formula, but haven't found any solutions posted.
I have a custom date field, "Deliverable Date" and a custom number field, "Acceptance Period (Days)".
If the Deliverable Date is 5/12/19 and the Acceptance Period (Days)" is 7, I'd like a fomula to add the 7 days to a custom formula field "Acceptance Date" that results in 5/19/19. And if the days were 6, then the Acceptance Date would be 5/18/19, and so forth.
Would this need to be a workflow vs. formula? Any advice would be appreciated. Thank you!
Type date
formula
Deliverable Date + Acceptance Period
example: Date_1__c + Acceptance_Period_Days__c
regards
Andrew
All Answers
Type date
formula
Deliverable Date + Acceptance Period
example: Date_1__c + Acceptance_Period_Days__c
regards
Andrew
https://opfocus.com/sfdc-formula-field-todays-date-plus-one-year/
or
Please Use Deliverable Date + Acceptance Period (Days)
Thanks
Rgds,
Stephen