Date and User Macros

Toni Tolvanen
2024-02-22T14:08:36Z

You can use the following date macros as search keys when searching for a date, and date and time:

Symbol | Meaning
now | the current day or moment
start_day | the beginning of the current day
start_week | the first day of the current week
start_month | the first day of the current month
start_quarter | the first day of the current quarter
start_half | the first day of the current half-year
start_year | the first day of the current year
end_day | the end of the current day
end_week | the last day of the current week
end_month | the last day of the current month
end_quarter | the last day of the current quarter
end_half | 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
y | year
M | month
d | day
h | hour
m | minute
s | second
w | 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# | userId
#userName# | name of the user data card (fallback is user id)
#user# | user data card
#user:code:code# | field of user data card