Forum Discussion
Formulas in Quickbase work very similarly to formulas in standard mathematics and also to formulas in Excel, so once you get into it, you'll realize they're a bit easier than you realized.
For your example, you've got 2 fields - [My Date] a Date field, and [My Number] a Number field. To add these together, they have to represent compatible values. Since Numbers can't be added to Dates, we'll have to change [My Number] to a Duration. To do that, would would create a formula like this:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
For your example, you've got 2 fields - [My Date] a Date field, and [My Number] a Number field. To add these together, they have to represent compatible values. Since Numbers can't be added to Dates, we'll have to change [My Number] to a Duration. To do that, would would create a formula like this:
Days([My Number])​
Days is a Function in Quickbase that converts a Numeric value to a Duration. This can then be used in calculations with Durations or Dates. To add this to your date value, we would just do a standard addition formula like this:[My Date] + Days([My Number])​
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Related Content
- 4 months ago
- 8 months ago
- 3 years ago