Date Filter Field

The G/L Account Table

In this field you can set a filter to filter amount fields by date.

If this field contains starting and ending dates for a time period, the values in the Net Change and Budgeted Amount fields will display the net change on an account during that period. The Balance at Date and Budget at Date fields will show the balance from the starting to the ending dates of the filter.

You can enter a date or a time interval. There are certain rules for how they should be entered:

Meaning

Sample Expression

Entries Included

Equal to

12 15 00

Only those posted on 12 15 00.

Interval

12 15 00..01 15 01

..12 15 00

Those posted on dates between and including 12 15 00 and 01 15 01.

Those posted on 12 15 00 or earlier.

Either/or

12 15 00|12 16 00

Those posted on either 12 15 00 or 12 16 00. If there are entries posted on both days, they will all be displayed.

You can also combine the various format types:

Sample Expression

Entries Included

12 15 00|12 01 00..12 10 00

Entries posted either on 12 15 00 or on dates between and including 12 01 00 and 12 10 00.

..12 14 00|12 30 00..

Entries posted on 12 14 00 or earlier, or entries posted on 12 30 00 or later - that is, all entries except those posted on dates between and including 12 15 00 and 12 29 00.

Attention

If you have the Balance at Date and/or Budget at Date fields in the chart of accounts, you can enter only one date or one interval in the Date Filter field. This means, for example, that you cannot enter the example given in the description of Either/or.