Date lookup calendar

×

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