How to add a number field to a date field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a date field and a numeric duration field.  How do I create a formula to add 

[DateField] + [DurationNumber] =

example I have an appointment scheduled for 5/10/2016 and it will take 3 days (duration field) the estimated completion date is 5/13/2016 

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
Did you try 

[DateField] + [DurationNumber] 




YOU said on one hand that the duration number was a duration field type and you also said it was a numeric field.



If in fact it is a numeric field tyeo then it would be



[DateField] + Days([DurationNumber])