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 quantity and amount fields will display the net change during that period.
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. |