--- id: post/sauravdhyani-com/tag-blogger-com-1999-blog-3122193036149030463-post-4662412510469862425--2edabbcaf9 type: post title: How to Use Date Formulas for Allowed Posting Periods in Business Central BC28. summary: Business Central BC28 introduces dynamic date formulas for allowed posting periods that automatically calculate posting windows based on the current date instead of requiring manual updates. Administrators can configure these formulas in General Ledger Setup, User Setup, and Journal Templates to automate posting restrictions and reduce monthly maintenance. tier: community language: en tags: - posting dates - date formulas - financial controls - posting restrictions - automation - general ledger - user setup system: finance review: state: reviewed by: opus at: "2026-10-08T01:54:07.850Z" flags: [] generated: at: "2026-10-08T01:26:53.141Z" pipeline: 0.2.0 prompts: extract-post: 1 input_hash: a1c3660056d2ac1da982aa571c596f3484848741a3fbe647d6f12c33427d241b evidence: - kind: blog url: https://www.sauravdhyani.com/2026/06/how-to-use-date-formulas-for-allowed.html title: How to Use Date Formulas for Allowed Posting Periods in Business Central BC28. date: "2026-07-22" commit: null t: null quote: null - kind: blog url: https://www.sauravdhyani.com/2026/06/how-to-use-date-formulas-for-allowed.html title: How to Use Date Formulas for Allowed Posting Periods in Business Central BC28. date: "2026-07-22" commit: null t: null quote: Posting date formulas allow Business Central to dynamically calculate allowed posting ranges based on today's date. - kind: blog url: https://www.sauravdhyani.com/2026/06/how-to-use-date-formulas-for-allowed.html title: How to Use Date Formulas for Allowed Posting Periods in Business Central BC28. date: "2026-07-22" commit: null t: null quote: Entering a formula clears the fixed date; entering a fixed date clears the formula. links: learn: [] objects: - object/table/98 - object/table/91 features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] post_id: tag:blogger.com,1999:blog-3122193036149030463.post-4662412510469862425 source_id: sauravdhyani-com source_name: Saurav Dhyani url: https://www.sauravdhyani.com/2026/06/how-to-use-date-formulas-for-allowed.html published_at: "2026-07-22T05:30:00.000Z" author: Saurav Dhyani full_text: false words: 536 quotes: - text: Posting date formulas allow Business Central to dynamically calculate allowed posting ranges based on today's date. why_it_matters: Explains the core capability that replaces manual posting date maintenance with automatic calculations - text: Entering a formula clears the fixed date; entering a fixed date clears the formula. why_it_matters: Important behavior that administrators need to understand when mixing formulas and fixed dates code_objects_mentioned: - table General Ledger Setup - table User Setup - table General Journal Templates systems: - finance - administration versions_mentioned: - BC28 - 2026 release wave 1 preview: embeddable: true frame_url: null image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAS8PDaausEZz2Hz5RH2JXLOabtbTv2hvetaoa6CubvVnyxa74ZSIUDm5WRRVK3d7hJjNeqHKQ1B3VEm8VYUYAwa-D3z3d9L5jYzAf9OxJPmDnXHbIb_8kgUzFaVWt1rv8YxQl5f_8yETLzySf5_RVv6b78bgsaAfH3lC5wAXdb6U8G_10Tl9A9yZPl5g/w1200-h630-p-k-no-nu/ChatGPT%20Image%20May%2024,%202026,%2011_44_23%20AM.png image_alt: null image_w: null image_h: null site_name: null favicon: https://www.sauravdhyani.com/favicon.ico probed_at: "2026-10-07T11:50:21.692Z" --- # How to Use Date Formulas for Allowed Posting Periods in Business Central BC28. [Read the post](https://www.sauravdhyani.com/2026/06/how-to-use-date-formulas-for-allowed.html) · Saurav Dhyani (Saurav Dhyani, MVP) · 2026-07-22 · 536 words · tier community · reviewed (checked by Opus) > Business Central BC28 introduces dynamic date formulas for allowed posting periods that automatically calculate posting windows based on the current date instead of requiring manual updates. Administrators can configure these formulas in General Ledger Setup, User Setup, and Journal Templates to automate posting restrictions and reduce monthly maintenance. ## 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"](../../objects/table/98.md) - [table 91 "User Setup"](../../objects/table/91.md) - 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.