Payment Terms for 2 Weeks

markborges

Hi everyone,

My customer wants a very different payment term:

When posting between 1 and 15 of a month, the due date must be 16 of the next month.
When posting between 16 and 31 of a month, the due date must be 31 of the next month.

Is there a way of doing this in only one Date Formula, or should I create 2 date formulas, and tell her to use them accordling to which day she is?

I've already created two:

From 1 to 15, formula: PM+16D
From 16 to 31, formula: PM+1M

I tested and it is ok, but I wanted to know if there's a way to use only one Date Formula...

Do you have any tips on this? :-k

Thanks in advance!

Alex_Chow

I don't believe the dateformula field allows for conditionals.