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
Because Today() will continue to be greater than the expiration term. so you have to set a range.
Let's try this:
If(Today()>=([Expiration]-Days(45) AND Today()<=[Expiration]), true and [Customer Status] = "Closed" and [Health Term] > 30)
That's giving me a syntax error.
