Share via


Date Filter Field, Payment History Table

In this field, you can set a date filter.

If this field contains the starting and ending dates for a time period, a field such as Remaining Amount will display the remaining amount for that time period only.

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 created on 12 15 00.

Interval

12 15 00..01 15 01
..12 15 00

Those created on dates between and including 12 15 00 and 01 15 01.
Those created on 12 15 00 or earlier.

Either/or

12 15 00|12 16 00

Those created either 12 15 00 or 12 16 00. If there are entries created 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 created 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 created on 12 14 00 or earlier, or entries created on 12 30 00 or later - that is, all entries except those created on dates between and including 12 15 00 and 12 29 00.

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
Payment History Table Netherlands Local Functionality
Payment History Table Netherlands Local Functionality