Page History

...

Complex due date calculation example

Case example 1 - yearly due date

a) if document date is before July 31, the due date is Jul 31 of the year.

b) if document date is after Jul 31, the due date is Jul 31 of the following year. 

Calculation formula can be 5M-CY+7M-1D, calculation b/d as below:

a) Document Date before Jul 31

...

b) Document Date after Jul 31

...

Case example 2 - quarterly due date

a) due date on 1st Monday after beginning of the next quarter from the document date

Calculation formula can be 3M-CQ+WD1, calculation b/d as below:

...

Reference: 

https://docs.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges#using-date-formulas