Loading search results...

Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceVBA Date FunctionsFloorTime

FloorTime

Returns the input timestamp with all time fields set to 00.

Syntax

FloorTime(TimeStamp)

Parameters

TimeStamp: The timestamp to return the floor of.

Example

[DateCustom].[Retail445].[Reporting Day].&[`FloorTime("2008-04-09T11:35:04.201103")`]