Filter: Date Column Filter Min, Max, Year, Half Year, Quarter, Month
Overview¶
Specify the minimum and maximum of the numerical value in years to be used when "Default" is selected in "Date Filter Mode Selection" in "Filter" of "Date Column". "Today", "This Month", and "This Year" are displayed as default filter options.
Limitations¶
- Only "Date Column" can be used.
Prerequisites¶
- "Site Administration Permission" is required to configure settings.
- The start month of "Fiscal Year", "Half Year", and "Quarter" is specified in "FirstMonth" in General.json. The default value is April.
Setting Content¶
| No | Option | Description |
|---|---|---|
| 1 | Min | If set to -1, the filter options will display dates from one year ago onwards. Enter the number of years as a negative integer. |
| 2 | Max | If set to 1, the filter options will display dates up to one year in the future. Enter the number of years as an integer. |
| 3 | Fiscal Year | If the "Checkbox" is enabled, "Fiscal Year" will be displayed in the filter options. |
| 4 | Half Period | If the "Checkbox" is enabled, "Half Year" will be displayed in the filter options. |
| 5 | Quarter Period | If the "Checkbox" is enabled, "Quarter" will be displayed in the filter options. |
| 6 | Month | If the "Checkbox" is enabled, "Month" will be displayed in the filter options. |
