Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceVBA Date FunctionsNowVersion: I2024.1.3On this pageNow Returns the current date and time (without a timezone), according to the underlying data warehouse's clock. Syntax Now() Example The following expression returns the current date and time: [Order Date Dimension].[Order Date Month Hierarchy].[Day].&[`CInt(Format(Now(), "yyyymmdd"))`]