About Date Filters

AptaFund 4.1 grids that contain dates can be filtered using exact or relative dates.

Exact dates

Filtering on exact dates is useful for one-time filters that are needed for a specific purpose.

Show invoices on a single date

Select = from the Operation field, and enter or select the date.

Show invoices in a date range

Enter the begin & end dates for the range. You can use the shortcut keys to select each date.
Note: The begin and end dates are included in the results.

Relative dates

Filtering using relative dates allows setting up grid settings that can be used in the future for routine data reporting or proofing without needing to adjust the filter.

All relative values are based on the current date — the date on which you're using the grid or running a grid report. As a result, filtering on relative dates will return different results when run on different days. For example, if a set of saved grid settings contains a date filter for Invoice Date within the last 4 weeks, you can open this saved grid setting on July 30th and see results for July. But if you open the saved grid setting on October 31st, you'll see results for October.

Using relative dates

To show all vendor invoices dated in the last two weeks, enter 2 in the Invoice Date within the last field, and select Weeks from the pull-down list.

To show all vendor invoices dated more than two weeks ago, enter 2 in the Invoice Date more than field, and select Weeks from the pull-down list.

To show all vendor invoices dated between 4 weeks ago and 3 weeks ago, enter -4w in the In Range field and -3w in the to field.

Return to About Filters