Forum Discussion
DanteTognoli
7 years agoQrew Captain
The time is in hours. It is generated from a duration calculation based on timestamp:
[Stamp OUT]-[Stamp IN]
Which generates the duration in hours to the field [Period Duration]. That field is used in the following formula:
If([Period Duration]>14,"Yes",null)
Which then generates the error below:
The expression [Period Duration] on the left hand side of the operator ">" is of type duration while the expression 14 on the right hand side is of type number. The operator ">" cannot be used with these types of expressions.
[Stamp OUT]-[Stamp IN]
Which generates the duration in hours to the field [Period Duration]. That field is used in the following formula:
If([Period Duration]>14,"Yes",null)
Which then generates the error below:
The expression [Period Duration] on the left hand side of the operator ">" is of type duration while the expression 14 on the right hand side is of type number. The operator ">" cannot be used with these types of expressions.