A script-enabled browser is required for this page to function properly.

Value if Null Format Mask property

The Value if Null Format Mask property specifies the format for the value specified by the Value if Null property for columns whose datatype is Date. This value is used by Reports Builder to interpret the Value if Null property. (It does not have any affect on how the column is displayed).

You can enter a custom mask for dates or you can select from the list of values. See Date and time format mask syntax for the correct syntax.

Applies to

Formula or Placeholder columns

Values

Any valid date format mask, not to exceed 1K

Default

The default for your language (for example, in the United States, the default is 'DD-MON-RR')

Required/Optional

Required, if Datatype is Date

Restrictions

Usage notes

Examples

Sample Date Format           Date Displayed
MM/DD/RR                     03/04/85
DD MON RRRR                  04 MAR 1985
Mon. DD, RRRR                Mar. 4, 1985
Day Month DD fmHH:MI AM      Monday  March 4 11:35 AM
Dy Mon ddth fmHH24:MI:SS     Mon Mar 4th 23:35:22
Day "the" ddthsp "of" Month  Monday the fourth of March