Skip to main content
Question

Help with calculating a date with formula fields

  • July 27, 2017
  • 0 replies
  • 50 views
This is the first semi-complicated formula I have tried and it is not working!

I have 2 fields that need to be involved in the calculation of Field #3

Field #1 - Date field
Field #2 - Numeric field
Field #3 - Formula - date (should it be something else?)

What I need Field #3 to calculate is this:
Field #1 + (Field #2 * 7)

This seems so simple, but I keep getting errors about mismatched types. I don't understand why Quickbase isn't smart enough to just add a number of days to a date.

Help!!!!!!!!
This topic has been closed for replies.

  • ChuckGrigsby
  • Quickbase Alumni
  • July 27, 2017
[Field1] + Days([Field2]*7)

Your formula should work if you change Field2 from numeric to duration
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • July 27, 2017
Now I am getting this error message:

The types of the arguments or the number of arguments supplied do not meet the requirements of the function Days.

The function is defined to be Days (Number n).
Terms & ConditionsAccessibility statement