Business Central - Manipulate date fields for reports or filters

HOME / Dynamics Business Central / Administration

less than 1 minute read

Objective

Sometimes we need to set date range by demand to get accurate output. It will show you how to manipulate date fields for reports or filters. Not that complicated but it has its own syntax.

Syntax

  1. Between date
    • Example: From 01/04/21 to 30/04/21 will be 01/04/21..30/04/21
  2. Transations on or before the date
    • Example: Before 01/04/21 will be ..01/04/21
  3. Transactions on or after the date
    • Example: After 01/04/21 will be 01/04/21..
  4. Transactions on either or these days
    • Example: Either 01/04/21 or 08/04/21 will be 01/04/21|08/04/21
NOTE - Date is in dd/mm/yy format.

Other posts in the category more...