Default Custom Filter Functions v2016.3+
Exago BI comes with a number of built-in custom filter functions. They are exposed in the Admin Console so they may be modified as needed.
If these functions are unavailable, such as after an upgrade, follow the restore instructions in the Default Custom Filter Functions v2016.3+ section above to add them back to the configuration automatically.
In all of the examples below, today’s date is assumed to be Friday, February 26, 2021.
FirstDayOfCurrentMonth
| Description | Returns a DateTime representing the first day of the current month |
|---|
| Example | 2/1/2021 |
|---|
FirstDayOfCurrentQuarter
| Description | Returns a DateTime representing the first day of the current quarter |
|---|
| Example | 1/1/2021 |
|---|
FirstDayOfCurrentYear
| Description | Returns a DateTime representing the first day of the current year |
|---|
| Example | 1/1/2021 |
|---|
FirstDayOfLastMonth
| Description | Returns a DateTime representing the first day of last month |
|---|
| Example | 1/1/2021 |
|---|
FirstDayOfLastQuarter
| Description | Returns a DateTime representing the first day of last quarter |
|---|
| Example | 10/1/2020 |
|---|
FirstDayOfLastYear
| Description | Returns a DateTime representing the first day of last year |
|---|
| Example | 1/1/2020 |
|---|
FirstDayOfNextMonth
| Description | Returns a DateTime representing the first day of next month |
|---|
| Example | 3/1/2021 |
|---|
FirstDayOfNextQuarter
| Description | Returns a DateTime representing the first day of next quarter |
|---|
| Example | 4/1/2021 |
|---|
FirstDayOfNextYear
| Description | Returns a DateTime representing the first day of next year |
|---|
| Example | 1/1/2022 |
|---|
FridayOfCurrentWeek
| Description | Returns a DateTime representing the Friday of the current week |
|---|
| Example | 2/26/2021 |
|---|
FridayOfLastWeek
| Description | Returns a DateTime representing the Friday of the previous week |
|---|
| Example | 2/19/2021 |
|---|
FridayOfNextWeek
| Description | Returns a DateTime representing the Friday of the next week |
|---|
| Example | 3/5/2021 |
|---|
LastDayOfCurrentMonth
| Description | Returns a DateTime representing the last day of the current month |
|---|
| Example | 2/28/2021 |
|---|
LastDayOfCurrentQuarter
| Description | Returns a DateTime representing the last day of the current quarter |
|---|
| Example | 3/31/2021 |
|---|
LastDayOfCurrentYear
| Description | Returns a DateTime representing the last day of the current year |
|---|
| Example | 12/31/2021 |
|---|
LastDayOfLastMonth
| Description | Returns a DateTime representing the last day of the previous month |
|---|
| Example | 1/31/2021 |
|---|
LastDayOfLastQuarter
| Description | Returns a DateTime representing the last day of the previous quarter |
|---|
| Example | 12/31/2020 |
|---|
LastDayOfLastYear
| Description | Returns a DateTime representing the last day of the previous year |
|---|
| Example | 12/31/2020 |
|---|
LastDayOfNextMonth
| Description | Returns a DateTime representing the last day of the next month |
|---|
| Example | 3/31/2021 |
|---|
LastDayOfNextQuarter
| Description | Returns a DateTime representing the last day of the next quarter |
|---|
| Example | 6/30/2021 |
|---|
LastDayOfNextYear
| Description | Returns a DateTime representing the last day of next year |
|---|
| Example | 12/31/2022 |
|---|
MondayOfCurrentWeek
| Description | Returns a DateTime representing Monday of the current week |
|---|
| Example | 2/22/2021 |
|---|
MondayOfLastWeek
| Description | Returns a DateTime representing Monday of the previous week |
|---|
| Example | 2/15/2021 |
|---|
MondayOfNextWeek
| Description | Returns a DateTime representing Monday of the next week |
|---|
| Example | 3/1/2021 |
|---|
Today
| Description | Returns a DateTime representing today’s date |
|---|
| Example | 2/26/2021 |
|---|
TodayMinus30Days
| Description | Returns a DateTime representing the date 30 days prior to today |
|---|
| Example | 1/27/2021 |
|---|
TodayMinus60Days
| Description | Returns a DateTime representing the date 60 days prior to today |
|---|
| Example | 12/28/2020 |
|---|
TodayMinus7Days
| Description | Returns a DateTime representing the date 7 days prior to today |
|---|
| Example | 2/19/2021 |
|---|
TodayMinus90Days
| Description | Returns a DateTime representing the date 90 days prior to today |
|---|
| Example | 11/28/2020 |
|---|
TodayPlus30Days
| Description | Returns a DateTime representing the date 30 days in the future from today |
|---|
| Example | 3/28/2021 |
|---|
TodayPlus60Days
| Description | Returns a DateTime representing the date 60 days in the future from today |
|---|
| Example | 4/27/2021 |
|---|
TodayPlus7Days
| Description | Returns a DateTime representing the date 7 days in the future from today |
|---|
| Example | 3/5/2021 |
|---|
TodayPlus90Days
| Description | Returns a DateTime representing the date 90 days in the future from today |
|---|
| Example | 5/27/2021 |
|---|
Tomorrow
| Description | Returns a DateTime representing tomorrow’s date |
|---|
| Example | 2/27/2021 |
|---|
Yesterday
| Description | Returns a DateTime representing yesterday’s date |
|---|
| Example | 2/25/2021 |
|---|
Additional Resources