Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Help with calculating a date with formula fields

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 f...
Formulas and functions
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
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).
ChuckGrigsby's avatar
ChuckGrigsby
Qrew Cadet
8 years ago
What field types do you have now?
Field #1 - Date field
Field #2 - Numeric field
Field #3 - Formula - date
If its like your original post then the formula date should be this
[Field1] + Days([Field2]*7)

If its like this
Field #1 - Date field
Field #2 - Duration field
Field #3 - Formula - date

formula would be this
[Field1] + ([Field2]*7)