Date Filter Field, G/L Account Table
Specifies the date interval that values are filtered by.
If this field contains starting and ending dates for a date interval, then other field values only show information for that interval. The Balance at Date and Balance at Date fields show the balance from the starting to the ending dates of the filter.
You can enter a date interval according to the following rules.
| Meaning | Sample expression | Entries that are included |
|---|---|---|
Equal to |
12 15 12 |
Only entries that are posted on December 15, 2012. |
Interval |
12 15 12..01 15 13 ..12 15 12 |
Entries that are posted on dates between and including December 15, 2012, and January 15, 2013. Entries that are posted on January 15, 2012, or earlier. |
Either/or |
12 15 12|12 16 12 |
Entries that are posted on either December 15, 2012, or December 16, 2012. If there are entries that are posted on both days, then all entries are displayed. |
You can also combine the various format types.
| Sample expression | Entries that are included |
|---|---|
12 15 12|12 01 12..12 10 12 |
Entries that are posted either on December 15, 2012, or on dates between and including December 1, 2012, and December 10, 2012. |
..12 14 12|12 30 12.. |
Entries that are posted on December 14, 2012, or earlier, or entries that are posted on December 30, 2012, or later, which includes all entries except those that are posted on dates between and including December 15, 2012, and December 29, 2012. |
Important
If you have the Balance at Date or Budget at Date fields, or both 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.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| G/L Account Table | General Ledger |
| G/L Account Table | General Ledger |