When you define a custom "search" (Manage Keys / search / edit searches), you can use macros in the SQL field that are automatically replaced when the search is performed.
| Macro | Description |
| [today_start] | 12:00:01 AM of the current day |
| [today_end] | 11:59:59 PM of the current day |
| [yesterday_start] | 12:00:01 AM of yesterday |
| [yesterday_end] | 11:59:59 PM of yesterday |
| [last_month_start] | 12:00:01 AM of the first day of the previous month |
| [last_month_end] | 11:59:59 PM of the last day of the previous month |
| [this_month_start] | 12:00:01 AM of the first day of the current month |
| [this_month_end] | 11:59:59 PM of the last day of the current month |
| [date] | Date the scheduled task last ran |
You can use + or - arithmetic operations within a macro.
For example:
[today_start-5] is equivalent to 5 days ago.
[today_start+5] is equivalent to 5 days from today.
Comments
0 comments
Article is closed for comments.