Available Date/Time Keywords

The following table describes the date/time keywords in SBM. When you use these Date/Time keywords, be sure to type them exactly as shown.

Date/time keyword

Description

now

Current date and time. If you use this keyword in a date only field, it is recognized as startof_today.

startof_today, startof_yesterday, startof_tomorrow, startof_thisweek, startof_nextweek, startof_lastweek, startof_thismonth, startof_lastmonth, startof_nextmonth, startof_thisyear, startof_lastyear, startof_nextyear

These Date/Time keywords return the beginning of a time period.

endof_today, endof_yesterday, endof_tomorrow, endof_thisweek, endof_nextweek, endof_lastweek endof_thismonth, endof_lastmonth, endof_nextmonth, endof_thisyear, endof_lastyear, endof_nextyear

These Date/Time keywords return the end of a time period.

Plus

Specifies a date of today plus a number of days. For example, to receive a date of 30 days from today, use "plus 30" in a date search or query-at-runtime field. The value after the keyword must be an integer up to 5,000 that specifies the number of calendar days to offset. The following Plus keywords are available by clicking the Date/Time Keywords link on forms:

  • Plus 7

  • Plus 30

  • Plus 365

Minus

Specifies a date of today minus a number of days. For example, to specify today minus 30 days, use "minus 30." The value after the keyword must be an integer up to -1,000 that specifies the number of calendar days to offset. The following Minus keywords are available by clicking the Date/Time Keywords link on forms:

  • Minus 7

  • Minus 30