checkbox [WARRANTY BILLING]
If([TO BE BILLED BY:]>(Today()+Days(11)),true,false)is not working...
Can you explain what is not working? What is the symptom of the problem?
The checkbox is not being checked
[TO BE BILLED BY:] is a date forumla field
[CURRENT SCHEDULE DATE]+Days(6)
The pretty simple formula so it certainly should work.
Can you prove with a screenshot on a particular record or on a report that it is not working? i.e. show me a screenshot where the [TO BE BILLED BY:] is more than 11 days in the future so after say March 29th and the checkbox is not checked?
Maybe it should be
[TO BE BILLED BY] < =(Today()+Days(11)),true,false)
If you can say in words what you want, then I can help with the formula.
If TO BE BILLED BY is 11 or more days in the past (from today), checkbox needs to be checked
[TO BE BILLED BY] < =Today()-Days(11)
Whew! I think that did it. Seems so simple now.