DATEFORMAT

Report Writer can be used prepare reports based on Date type members. Report writer display format directives that apply to numeric values apply to Date type values also. The following format directive formats all the output cells based on the outline’s date format string:

{OUTFORMATTEDVALUES}

Report Writer post-processing commands that operate on numeric data, such as like RESTRICT, TOP, BOTTOM and SORT, will operate on internal numeric date values.

Syntax

{ DATEFORMAT “string” }
ParameterDescription

“string”

A string in one of the date format string supported by Essbase

Example

See Also
  • WITHATTR