Forum Discussion
ArchiveUser
8 years agoQrew Captain
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).
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).
ArchiveUser
8 years agoQrew Captain
I thought that solved it, but when I actually tried it with values it is calculating completely incorrectly.
The fields are:
Field #1 - Date field
Field #2 - Duration field
Field #3 - Formula - date
The formula is:
[Field #1] + ([Field #2]*7)
The Duration field is representative of weeks (1 week, 2 weeks, etc.)
This formula is supposed to take a start date and calculate a due date that is X weeks later.
The Duration field has a value display dropdown option for weeks, which is what I selected (although I'm not sure what affects). This seems like it should work, I am at a loss as to why it does not.
Also, I really appreciate your help!
The fields are:
Field #1 - Date field
Field #2 - Duration field
Field #3 - Formula - date
The formula is:
[Field #1] + ([Field #2]*7)
The Duration field is representative of weeks (1 week, 2 weeks, etc.)
This formula is supposed to take a start date and calculate a due date that is X weeks later.
The Duration field has a value display dropdown option for weeks, which is what I selected (although I'm not sure what affects). This seems like it should work, I am at a loss as to why it does not.
Also, I really appreciate your help!