ContributionsMost RecentMost LikesSolutionsRe: how do I use ""or"" on a commission calculation formula?Thank you! I'm testing right now.how do I use ""or"" on a commission calculation formula?I'm calculation commissions. I'm trying to use a formula that says; if ( [carrier x] or [carrier y] or [carrier z] , [monthly premium]*[health plan commission]) Thanks!Re: days until expiration checkboxThat appears to have worked. Thank you so much!Re: days until expiration checkboxIf(Today()>=([Expiration]-Days(45)AND Today()<=[Expiration]) and [Customer Status] = "Closed" and [Health Term] > 30,true,false)Re: days until expiration checkboxThat's giving me a syntax error.days until expiration checkboxI 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 if we are within 45 days of the policy expiration date and it does this. The issue is if the expiration date has passed the box doesn't unchecked. Any assistance would be appreciated. Thanks!Re: Adding days to a date field.Worked like a charm! Thanks!Adding days to a date field.I have policies that expire in a specific number of days. Using the AdjustMonth function causes the expiration to be inaccurate. I have a numeric field with the number of days. "Term Days" How do I calculate the expiration date base on the effective date? Fields are "Policy Effective Date" which is a date field and "Policy Expiration Date" which is a Date - Formula field. Thanks!