Due Date Calculation on Customer Card

icarus1306

Hello,

I need to know what date formula to enter to achieve the following:

To show you the calculation I need to happen I give you 2 examples:

30days EOM = invoice date 13/03/09 due date 30/04/09
60days EOM = invoice date 13/03/09 due date 31/05/09

If you quote me the formula for each separately I would be obliged.

The same formula would also need to cater for February.

Regards


Andrew

matttrax

I believe you can do

1M+CM
2M+CM

You can't easily do 30 and 60 days I don't think because on January 31st, adding 30 days will get you into March.

DenSter

Just to elaborate a little:
-CM gives you the 1st day of the Current Month
+CM gives you the last day of the Current Month

So from 03/13/2009;
+2M gives you 05/13/2009
+CM from there gives you the last day of month 05: 05/31/2009

This works from any month. If you start with 01/31, and you do +1M, you end up with 02/28, so that is already smart enough to know not to go into the month after that.