Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
5 years ago

Which type conversion for adding days to a date field?

I've searched through the Quick Base community using so many keywords and can't seem to find the answer to what I need.  I have a date field [Letter Date] and a text-multiple choice field [# of Days U...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try this

[Letter Date] + Days(ToNumber([# of Days Until Due]))


// the formula above first converts the multiple choice text field for days from text to a number.  Then converts that to a duration of the # of days and adds that to the date.​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • dbryant4891's avatar
    dbryant4891
    Qrew Trainee
    5 years ago
    Thank you Mark, that did exactly what I was looking for!

    ------------------------------
    Danaya Bryant
    Business Analyst
    The van Halem Group
    Atlanta GA
    ------------------------------