5g: PeriodsLabelsλ()

Description

PeriodsLabelsλ() translates dates to various intervals and formats them so they can be sorted in reports and pivots.

Syntax

PeriodLabelλ(Date, [Interval], [Diagnostics])

Date (Required)
A single date or array of date(s) where the first date is the first date of a calendar year.

Interval (Optional)
Must be one of:

D Daily

W Weekly

I Weekly (using ISO week number)

M Monthly

Q Quarterly

S Semi-Annually

A or Y Annually

Diagnostics (Optional)

If TRUE, input errors that can occur after formula entry will display as diagnostic messages. The default is FALSE. It is recommended that models have a named range called Diagnostics and this named range be set to TRUE during model development and then set to FALSE when the model is placed into production.

Example

In this example we see a timeline as it is normally presented and below it we see it presented with period labels.