How to Use Date Formulas for Allowed Posting Periods in Business Central BC28.

Key points

• Date formulas dynamically calculate posting ranges using expressions like <-CM>, <0D>, and <-30D> that adjust automatically over time
• Formulas can be configured at three levels: Global (General Ledger Setup), User-specific (User Setup), and Journal-specific (General Journal Templates)
• User Setup restrictions take priority over other posting controls when multiple levels are configured
• Administrators can mix formulas and fixed dates together, though entering one clears the other for the same boundary
• Feature reduces monthly administrative effort while improving posting governance and preventing outdated posting windows

Quotes

• “Posting date formulas allow Business Central to dynamically calculate allowed posting ranges based on today’s date.” (Explains the core capability that replaces manual posting date maintenance with automatic calculations)
• “Entering a formula clears the fixed date; entering a fixed date clears the formula.” (Important behavior that administrators need to understand when mixing formulas and fixed dates)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

• table 98 “General Ledger Setup”
• table 91 “User Setup”
• table “General Journal Templates”

Not found in BC28-30: table “General Journal Templates”.

Context

• Features: Dynamic date formulas for posting periods, Current month posting control, Rolling adjustment windows, User-specific posting restrictions, Hybrid formula and fixed date support, Automated posting window calculation, Multi-level posting governance
• Versions: BC28, 2026 release wave 1

Source: Saurav Dhyani, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.