Date expression keywords
Date expression keywords
The list below shows keywords which can be used in date expressions. You can combine keywords to define relative dates such as "Friday of last week" or "Wednesday of next week".
Date expressions use the current week as the default frame of reference. For example, if today is Thursday, November 7 and you enter the date expression "Tuesday", the result is Tuesday, November 5.
PERIODS | CURRENT | FIRST | SUNDAY | OF |
QSTRING (quoted literal string) | LAST | END | MONDAY | - |
CALENDAR | PRIOR | DAYS | TUESDAY | + |
YESTERDAY | NEXT | WEEKS | WEDNESDAY | |
TODAY | FOLLOWING | MONTHS | THURSDAY | |
TOMORROW | NUMBER (decimal integer) | QUARTERS | FRIDAY | |
THIS | BEGINNING | YEARS | SATURDAY |