DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceVBA Date FunctionsPrevMonthStartDate

PrevMonthStartDate

Given the input date, returns a date representing the first day of the previous Gregorian calendar month.

Syntax

PrevMonthStartDate(Date)

Parameters

Date
The date to return the previous month's start date for.

Example

The following expression returns the first day of the month before 2005-08-15 occurred:

[DateCustom].[StandardMonth].[Month].&[`PrevMonthStartDate("2005-08-15T12:30:10")`]