AddCombinedDateFilter Procedure

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.0