Date Filter Field, Purchase Header Table

Specifies the date or time interval that values in quantity or amount fields are filtered by.

If this field contains starting and ending dates for a time interval, then the values in the quantity and amount fields will display the net change during that interval.

Enter a date or a time 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.

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
Buy-from Vendor Name 2 Field, Purchase Header Table Purchases and Payables
Purchase Header Table Purchases and Payables
Purchase Header Table Purchases and Payables

See Also

Reference

Purchase Order
Amount

Other Resources

Setting Filters