May 1, 200817 yr I know this sounds simple, but I'm getting beat up on it. : [color:green]I am creating a "Bill Payment" database and I have a field called "Monthly?". It is based on a Yes/No Value List. I need a calculation that if the answer is Yes, it will take the entered "Due Date" and add 1 month to that and place it in the field called "Next Due Date". Thanks,
May 1, 200817 yr Case ( Monthly = "Yes"; Date ( Month (Due Date) +1; Day (Due Date); Year (Due Date) ) )
Create an account or sign in to comment