Date/Time Shortcuts

The following table outlines the date/time shortcuts that you can use in calculation formulas.

Table 1. Date/Time Shortcuts
ShortcutDescription
NowNow (the time and date that you execute the query)
TodayToday at midnight
YesterdayYesterday at midnight
BOYFirst day of year at midnight
EOYLast day of year at midnight
BOMFirst day of month at midnight
EOMLast day of month at midnight

Relative Date/Time Shortcuts

Optionally, you can add or subtract relative times to the following absolute times. You must use them in conjunction with the date/time shortcuts listed in the preceding table (for example, Today+5h+3min instead of 5h3min).
  • Second
  • Minute
  • Hour
  • Day
  • Week