Ad Hoc Where and Sort Fields Menu
Optional context functions for AdHoc Where and Sort fields typicaly found in report selection windows.
Line |
Function |
Keys |
---|---|---|
|
Opens a column selection listing to allow insertion of an appropriate column name. This is the only menu items available both on Adhoc extra where fields and Adhoc pre-sort fields. Other lines are not available in Adhoc pre-sort fields. |
|
Yesterday Only |
For yesterday only. |
|
Today Only |
For today only. |
|
Last 7 Days |
The last 7 days to yesterday. |
|
Last Week |
Last week ending last Sunday. |
|
Last 2 Weeks |
Last 2 weeks ending last Sunday. |
|
Last 4 Weeks |
Last 4 weeks ending last Sunday. |
|
This Month |
From the start of the current month to today. |
|
Last 6 Weeks |
Last 6 weeks ending last Sunday. |
|
Last Month |
Last calendar month. |
|
Last 3 Months |
Last 3 calendar months. |
|
This Year |
This calendar year to today. |
|
Last Year |
Last calendar year. |
|
Last 2 Years |
Last 2 calendar years. |
|
Last 5 Years |
Last 5 calendar years |
|
See also: – |
Compiled in Program Version 5.10. Help data last modified 7 Jan 2015 09:03:00.00. Class mAdHocWhereSort last modified 18 Feb 2015 01:54:08.