Forum Discussion
ChrisChris
9 years agoQrew Assistant Captain
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)
ChrisChris
9 years agoQrew Assistant Captain
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)