Syntax Error
Formula syntax error There must be a valid expression inside parentheses.
AdjustMonth([Grease Location Opening Date],(ToNumber([FREQUENCY])/4),( Date d)Firstdayofweek)) The "Grease Location Op...
Forum Discussion
Try this Laura:
FirstDayOfWeek([Grease Location Opening Date]+[FREQUENCY])
------------------------------
Adam Keever
------------------------------
FirstDayOfWeek([Grease Location Opening Date]+[FREQUENCY])
------------------------------
Adam Keever
------------------------------
| The expression [Grease Location Opening Date] on the left hand side of the operator "+" is of type date while the expression [FREQUENCY] on the right hand side is of type number. The operator "+" cannot be used with these types of expressions. |
------------------------------
Laura Diak
------------------------------
- Change field type to duration and set value display to weeks:
------------------------------
Adam Keever
------------------------------