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.