Hello forum.  I'm trying to come up with a calculation to do the following. I know my date calc is wrong, but date calcs are just not my strong suit.

It works everywhere except when crossing thru February.  It's based on 3 fields with the calculation in the due date field:

terms (30,60,90,120 days based on a value list),invoice date, and due date

I'm trying to do 1, 2, 3, 4 months, minus a day.  So technically, I think I'm doing it right, just not getting the desired result.

Results:

Invoice date           terms           due date

11/30/2016            90 days          02/29/17  <<doesn't work, gives 3/1/17

11/30/2016            60 days          01/29/17    <<works

11/30/2016            30 days         12/29/2016   <<works

11/30/2016            120 days       03/29/2017   <<works.

 

Here's the calc:

Date(Month(PAYMENTS::date_invoice)+(PAYMENTS::terms/30);Day(PAYMENTS::date_invoice)-1;Year(PAYMENTS::date_invoice))

Sample attached in FM12

Any help or pointers are always greatly appreciated

Thanks

Steve

 

PAYMENTS.fmp12

Edited April 18, 20178 yr by Steve Martino
additional info

See if this helps:
http://fmforums.com/topic/59942-frequency/#comment-284146

This is as easy as breathing for you, isn't it?

The native way with a limit works perfectly.

Thanks (again and again) comment, I really appreciate it.

Steve