Table of Contents

AddCombinedDateFilter Procedure

Codeunit Combined Date Filters

Adds a new Combined Date Filter to the system.

Signature

[InherentPermissions(PermissionObjectType::TableData, Database::"QWEEG Combined Date Filter", 'RIM')]
AddCombinedDateFilter(Code: Code[20]; Description: Text; DateFilter: Text[2000])

Parameters

Code Code[20]

The code of the Combined Date Filter. This code must be unique, otherwise the existing Combined Date Filter will be overwritten. Try to use the same naming convention as the standard Combined Date Filters.

Description Text

The description of the Combined Date Filter, as shown to the user.

DateFilter Text[2000]

The definition of the Combined Date Filter. The date filter can be a combination of Date Formulas and Date Ranges. The format is specified as

  • DateExpression = < Subexpression > [< Separator > < Subexpression > ] [< Separator > < Subexpression > ]
  • Subexpression = {DR,[Date Range Code]} | {DF,[Date Formula Code]}
  • Separator = < Interval > | < Either/or >
  • Interval = ..
  • Either/or = |

If the Subexpression is a Date Range (first parameter is DR), the expression will be replaced with a date range expression. If the Subexpression is a Date Formula (first parameter is DF), the expression will be replaced with a date formula expression.

Example

CombinedDateFilters.AddCombinedDateFilter('CD+/BLANK', 'Current Date - No ending date or Blank date', '{DR,CD+}|{DF,BLANK}');
CombinedDateFilters.AddCombinedDateFilter('CM+/BLANK', 'Current Month - No ending date or Blank date', '{DR,CM+}|{DF,BLANK}');

This documentation is generated from Eagle v27.6