Not crazy about Date Formulas in Business Central?

Dynamics 365 Business Central

The article discusses the author's journey of understanding date formulas in Recurring Journals in Business Central.
The author initially found date formulas confusing but had an "Aha" moment that led to a new approach.
The "Old" way of setting date formulas involved a complex formula "1d+1m-1d" to calculate the last day of the next month.
The author's need to understand the "why" behind the formula led to a new way of thinking about date formulas.
Introducing the use of "C" in date formulas as a translation for "Current" helped simplify the process.
The article highlights a more concise formula shared by Robb Delprado, "1M+CM," to calculate the last day of the next month.
The new formula simplifies the process by adding one month and getting the completion of the month to determine the last day accurately.
The author encourages readers to choose the formula that works best for them and shares their experience with date formulas in Business Central.

Registered users can view the full text for FREE!