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 would check the field types of your two result conditions. I suspect that one of them is a date field and the other one might be a date/time field.
You need to decide what field type your formula is for and make sure that the results tmatch that.
You probably have to convert the date modified fieldto be a date field.
ToDate([Date Modified])
You need to decide what field type your formula is for and make sure that the results tmatch that.
You probably have to convert the date modified fieldto be a date field.
ToDate([Date Modified])