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)
Would you not want to reconstruct this statement thusly?
If(Today()>=([Expiration]-Days(45) AND Today()<=[Expiration]) and [Customer Status] = "Closed" and [Health Term] > 30,true,false)
- That's giving me a syntax error.
will you paste here what you have done?
- If(Today()>=([Expiration]-Days(45) AND Today()<=[Expiration]) and [Customer Status] = "Closed" and [Health Term] > 30,true,false)
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.
- That appears to have worked.
Thank you so much!
