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 values in the Net Change and Balance at Date fields show the net change and balance during that interval.

The following tables show the rules for entering a date interval.

Meaning Sample expression Entries that are included

Equal to

15.12.2012

Only entries that are posted on December 15, 2012.

Interval

15.12.2012..15.01.2013

..15.12.2012

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

15.12.2012|16.12.2012

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

15.12.2012|01.12.2012..10.12.2012

Entries that are posted either on December 15, 2012, or on dates between and including December 1, 2012 and December 10, 2012.

..14.12.2012|30.12.2012..

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.

Tip

See Also