Working with Data ModelsCreating ModelsModeling MetricsAdd Calculated MetricsMDX ReferenceVBA Date FunctionsNowOn 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"))`]