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)
Can we try this without the parentheses around the date range like so:
If(
Today()>=[Expiration]-Days(45) AND Today()<=[Expiration] and [Customer Status] = "Closed" and [Health Term] > 30,true,false
)
If you get another syntax error, please tell us what is says.