VBA Date Functions

AtScale supports a number of Microsoft Visual Basic Analysis (VBA) functions, which can be used in MDX expressions to create dynamic default members on time hierarchies. This enables you to create default members that update automatically over time; for example, the current day. For more information on default hierarchical members, see About Default Hierarchical Members.

AtScale supports the following VBA date functions:

• CurrentTimestamp
• DateAdd
• Day
• FloorTime
• Format
• Month
• MonthEndDate
• MonthStartDate
• Now
• PrevMonthStartDate
• PrevQuarterStartDate
• PrevWeekStartDate
• PrevYearStartDate
• Quarter
• QuarterEndDate
• QuarterStartDate
• selectMaxDate
• TimeStampAdd
• Week
• WeekDay
• WeekEndDate
• WeekStartDate
• Year
• YearEndDate
• YearStartDate