About Date and Time functions

Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. These functions are not supported by the Analytical Engine, so they must be calculated by the database.

For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference.

The MicroStrategy Analytical Engine does not calculate Date and Time functions. If your database does not include SQL syntax support for Date and Time functions, the functions cannot be calculated in your environment.
The results returned by the date/time functions may differ depending on the way your database stores and interprets dates, for example, whether Monday is considered the first or second day of the week.

For details on a specific Date and Time function, view one of the following topics:

For more information on the syntax used on your specific database, refer to the MicroStrategy Functions Reference.