
|
Field Data Type
|
Literal*
|
Effect
|
|---|---|---|
|
Date
|
TODAY
|
Match date to today's date
|
|
Date
|
TOMORROW
|
Match date to today + 1
|
|
Date
|
YESTERDAY
|
Match date to today - 1
|
|
Date
|
THIS_WEEK
|
Check if date is in the current week
|
|
Date
|
THIS_MONTH
|
Check if date is in the current month
|
|
Date
|
NEXT_WEEK
|
Check if date is in the next week
|
|
Date
|
NEXT_MONTH
|
Check if date is in the next month
|
|
Date
|
LAST_WEEK
|
Check if date is in the last week
|
|
Date
|
LAST_MONTH
|
Check if date is in the last month
|
|
Date
|
NEXT_90_DAYS
|
Check if date is in (tomorrow + 90)
|
|
Date
|
LAST_90_DAYS
|
Check if date is in (yesterday - 90)
|
|
Date
|
NEXT_N_DAYS:N
|
Check if date is in (tomorrow + N)
|
|
Date
|
LAST_N_DAYS:N
|
Check if date is in (yesterday - N)
|
|
Lookup (User)
|
SVMX.CURRENTUSER
|
Use login user's ID
|
|
* Literals are case-sensitive.
|
||