function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Marc Bowen 4Marc Bowen 4 

calculate future date when entering a number in a field

Hi All,

Is it possible to enter a number in a field and then the output ill be a date in the future?

eg. say i enter in 30 then the output will be today() + 30, so 04/03/2021
Best Answer chosen by Marc Bowen 4
Malika Pathak 9Malika Pathak 9
Hi Marc,
please find the solution

for this, you have to make another field as
formula field of date type and formula would be TODAY()+ number_field__c (output will be in MM:DD: YY)
where number_field__c contains the number you entered if this field remains empty the output would be the current date.

If you find this solution is helpful for you please mark this as the best answer.

All Answers

Malika Pathak 9Malika Pathak 9
Hi Marc,
please find the solution

for this, you have to make another field as
formula field of date type and formula would be TODAY()+ number_field__c (output will be in MM:DD: YY)
where number_field__c contains the number you entered if this field remains empty the output would be the current date.

If you find this solution is helpful for you please mark this as the best answer.
This was selected as the best answer
Marc Bowen 4Marc Bowen 4
Thanks so much Malika!!