Code required for calculating a payment due date in a field that relies on two other fields, payment schedule and last payment date.
Payment schedule is:
‘M'(Monthly), ‘Q'(Quarterly) , ‘S'(Semi Annually)or ‘A'(Annually).
If payment selected is ‘Q’ and last payment date is 11/1/2003, when is next payment due ???
I need the next payment due field to be populated automatically based on the two other fields.
Don’t forget the leap year issue.