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 RESTRICT, TOP, BOTTOM and SORT, will operate on internal numeric date values.

Syntax

{ DATEFORMAT “string” }

Parameters

“string”

One of the date format strings supported by Essbase.