Forum Discussion

DanayaBryant's avatar
DanayaBryant
Qrew Trainee
4 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
Qrew Champion
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
------------------------------
DanayaBryant's avatar
DanayaBryant
Qrew Trainee
4 years ago
Thank you Mark, that did exactly what I was looking for!

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