days until expiration checkbox
I have a checkbox that is functioning almost as its supposed too. If(Today()>=([Expiration]-Days(45)), true and [Customer Status] = "Closed" and [Health Term] > 30) I want the box to be checked ...
Forum Discussion
I am trying a similar thing, but not having any luck.
If(
(not IsNull([Date Completed]) and [Status]="Completed"),[Date Completed],[Date Modified])
This is what it says:
The types of the arguments or the number of arguments supplied do not meet the requirements of the function If.
The function is defined to be If (Boolean condition1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
If(
(not IsNull([Date Completed]) and [Status]="Completed"),[Date Completed],[Date Modified])
This is what it says:
The types of the arguments or the number of arguments supplied do not meet the requirements of the function If.
The function is defined to be If (Boolean condition1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
- Choose the right number and type of arguments.
- Use a type conversion function to convert the arguments you are using to the correct type.
- Choose a different function.