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:
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/------------------------------
