---
id: post/sauravdhyani-com/tag-blogger-com-1999-blog-3122193036149030463-post-6476700913383925526--f5fa15da26
type: post
title: Automating Posting Periods in Business Central with Date Formulas
summary: Date formulas enable automatic posting period adjustments in Business Central based on today's date instead of fixed dates. This feature applies to General Ledger Setup, User Setup, and General Journal Templates, reducing manual updates and posting errors.
tier: community
language: en
tags:
  - posting periods
  - date formulas
  - business central 2026
  - wave 1
  - automation
  - general ledger
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:54:57.106Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: e19e3e9de9539b9339044f330bd2ba258d49807b7a12edced97f2d484580d966
evidence:
  - kind: blog
    url: https://www.sauravdhyani.com/2026/06/automating-posting-periods-in-business.html
    title: Automating Posting Periods in Business Central with Date Formulas
    date: "2026-06-03"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.sauravdhyani.com/2026/06/automating-posting-periods-in-business.html
    title: Automating Posting Periods in Business Central with Date Formulas
    date: "2026-06-03"
    commit: null
    t: null
    quote: Date formulas are dynamic expressions that calculate allowed posting ranges relative to today's date.
  - kind: blog
    url: https://www.sauravdhyani.com/2026/06/automating-posting-periods-in-business.html
    title: Automating Posting Periods in Business Central with Date Formulas
    date: "2026-06-03"
    commit: null
    t: null
    quote: You can combine formulas with fixed dates - one boundary can be dynamic, the other fixed.
links:
  learn: []
  objects:
    - object/table/98
    - object/table/91
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: tag:blogger.com,1999:blog-3122193036149030463.post-6476700913383925526
source_id: sauravdhyani-com
source_name: Saurav Dhyani
url: https://www.sauravdhyani.com/2026/06/automating-posting-periods-in-business.html
published_at: "2026-06-03T05:30:00.000Z"
author: Saurav Dhyani
full_text: false
words: 279
quotes:
  - text: Date formulas are dynamic expressions that calculate allowed posting ranges relative to today's date.
    why_it_matters: This explains the core concept of how date formulas work as smart boundaries that move with time rather than being static.
  - text: You can combine formulas with fixed dates - one boundary can be dynamic, the other fixed.
    why_it_matters: This flexibility allows organizations to implement hybrid approaches that mix static and dynamic posting period controls.
code_objects_mentioned:
  - table General Ledger Setup
  - table User Setup
  - table General Journal Templates
systems:
  - finance
  - administration
versions_mentioned:
  - 2026 Wave 1
preview:
  embeddable: true
  frame_url: null
  image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtOcAw3jDGaS9Ce4KFFneWoxdbBYdsqv26UzB7GJ8Oht6Wm6nk91RD0a0WMIazXDQCVE7-17hHlVwtcrnbhBfVi6E0Bp2Z849zRz6u-oooaLErXv6WxJRcy3RdZPSh50791HuH1uJtIllJTn3OqHqecvlxeXug9UsgalXf8ToeogX22AOnr1NS9glzBm0/w1200-h630-p-k-no-nu/45b4b951-bd49-47b9-8225-16f6fc4d6489.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:32.004Z"
---

# Automating Posting Periods in Business Central with Date Formulas

[Read the post](https://www.sauravdhyani.com/2026/06/automating-posting-periods-in-business.html) · Saurav Dhyani (Saurav Dhyani, MVP) · 2026-06-03 · 279 words · tier community · reviewed (checked by Opus)

> Date formulas enable automatic posting period adjustments in Business Central based on today's date instead of fixed dates. This feature applies to General Ledger Setup, User Setup, and General Journal Templates, reducing manual updates and posting errors.

## Key points

- Date formulas define allowed posting ranges relative to the current date, so posting windows move automatically instead of needing manual updates.
- They can be set in General Ledger Setup, User Setup and General Journal Templates.
- Restrictions are checked in order: User Setup, then General Ledger Setup, then General Journal Template when its mandatory toggle is on.
- Examples include current month only, rolling 30 days, previous month close and today only.
- A formula can be used for one boundary while the other boundary stays a fixed date.

## Quotes

- "Date formulas are dynamic expressions that calculate allowed posting ranges relative to today's date." (This explains the core concept of how date formulas work as smart boundaries that move with time rather than being static.)
- "You can combine formulas with fixed dates - one boundary can be dynamic, the other fixed." (This flexibility allows organizations to implement hybrid approaches that mix static and dynamic posting period controls.)

## 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: Date formulas for posting restrictions, Dynamic posting windows, Automated posting period management, Relative date calculations
- Versions: 2026 Wave 1

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