Date and User Macros
You can use the following date macros as search keys when searching for a date, and date and time:
Symbol |
Meaning |
|
the current day or moment |
|
the beginning of the current day |
|
the first day of the current week |
|
the first day of the current month |
|
the first day of the current quarter |
|
the first day of the current half-year |
|
the first day of the current year |
|
the end of the current day |
|
the last day of the current week |
|
the last day of the current month |
|
the last day of the current quarter |
|
the last day of the current half-year |
end_year |
the last day of the current year |
Additionally, when using the macros, you can include an integer at the end of the string as follows: ±nx, where the symbol x may be any of the symbols listed below:
Symbol |
Meaning |
|
year |
|
month |
|
day |
|
hour |
|
minute |
|
second |
|
week |
For example, macro now+2M returns a date that is two months from the current date.
You can also use the user macros listed in Table 26: User macros usable in searches. These are useful in cases where you want to search for data cards containing your user id or the name of your user data card. You can also search data cards which contain a field having the same value as your user data card, or which refer to your user data card.
Note:
User macros work only with the search operators “Like” and “Not like”.
Macro |
Meaning |
|
userId |
|
name of the user data card (fallback is user id) |
|
user data card |
|
field of user data card |
Table of Contents